Basic Populating ListBox Problem

[checkai]

Here is what I am doing...

I have a txtBox that I type a value into...then the Search button should retrieve multiple values from the db based on the item entered and place them in the list box....

I started using the dataadapter, dataset, connection objects...

here is my code on the click event...

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
lbxClientSearch.Items.Clear()
Dim str As String
str = "Select searchName from tblClient"
sdaClient.SelectCommand.CommandText = str
conClient.Open()
sdaClient.SelectCommand.ExecuteNonQuery()
lbxClientSearch.DataSource = DsClient1
lbxClientSearch.DataBind()
conClient.Close()

sdaClient.Fill(DsClient1)
lbxClientSearch.DataBind()
End Sub


Any ideas...I am very new to .NET...

THANKS!!

DLC

 

[checkai]

ok, the second i submitted this thread...

I GOT IT TO WORK!!!

thanks anyway!!