Hi,
I'm new using AJAX and I'm developing a page where I need to populate a CheckBoxList based on what the user types (it's like an AutoSuggest). I don't know how to bind the checkboxlist from the database using AJAX.
My code in VB.NET is something like this:
- Dim DatabaseConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("MyServer").ConnectionString)
-
Dim selectSQL As String = "SELECT Name, Id FROM myTable"
-
Dim selectCMD As New SqlCommand(selectSQL, DatabaseConnection)
-
selectCMD.Parameters.Add(New SqlParameter("@name", SqlDbType.VarChar))
-
selectCMD.Parameters("@name").Value = MyTextBox.Text
-
-
Dim adapter As New SqlDataAdapter
-
Dim dTable As New DataTable
-
adapter.SelectCommand = selectCMD
-
adapter.Fill(dTable)
-
-
MyCheckBoxList.DataSource = dTable
-
MyCheckBoxList.DataTextField = "Name"
-
MyCheckBoxList.DataValueField = "Id"
-
MyCheckBoxList.DataBind()
I think the binding in Ajax would be similar to this, but I don't know. Please, can anyone help me with this?
Thanks a lot!
Ana
