Anupam Dutta

Latest Post

AutoComplete From Database Using AutoCompleteExtender

To Create an AutoComplete TextBox in asp.net use following instructions: 1. Create a webmethod GetDivisionInfo public string[] GetDivisionInfo(string prefixText) { string connStr = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString; int count = 10; string sql = “Select * from Division Where vDivisionName like @prefixText”; SqlDataAdapter da = new SqlDataAdapter(sql,connStr); da.SelectCommand.Parameters.Add(“@prefixText”, SqlDbType.VarChar, 50).Value = prefixText+ “%”; DataTable dt = new DataTable(); … Continue reading »