I'm trying to tie the AJAX autocomplete control to a textbox and pull the results from an sql database using VB. Anyone know how to do this? I found plenty of examples in c but I need to do it in VB. Here's code for C I guess but I can't figure out how
to convert it to VB. If you know of a better way to do this, please let me know. Thanks in advance..
[WebMethod]
public string[] GetCountryInfo(string prefixText)
{
int count = 10;
string sql = "Select * from Country Where Country_Name like @prefixText";
SqlDataAdapter da = new SqlDataAdapter(sql,”Your Connection String Comes Here”));
da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText+ "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["Country_Name"].ToString(),i);
i++;
}
return items;
}
GuyCre8ive
Member
173 Points
296 Posts
Implement AJAX AutoComplete from SQL database using VB
Oct 15, 2008 04:40 PM|LINK
I'm trying to tie the AJAX autocomplete control to a textbox and pull the results from an sql database using VB. Anyone know how to do this? I found plenty of examples in c but I need to do it in VB. Here's code for C I guess but I can't figure out how to convert it to VB. If you know of a better way to do this, please let me know. Thanks in advance..
[WebMethod] public string[] GetCountryInfo(string prefixText) { int count = 10; string sql = "Select * from Country Where Country_Name like @prefixText"; SqlDataAdapter da = new SqlDataAdapter(sql,”Your Connection String Comes Here”)); da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText+ "%"; DataTable dt = new DataTable(); da.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { items.SetValue(dr["Country_Name"].ToString(),i); i++; } return items; }