Query Code Does not work

[programmer_21]

I want to know in this is code connecting with sql server 2000 with Northwind Table :​

Dim cmdCust As New System.Data.SqlClient.SqlCommand()cmdCust.CommandText = "Select * From Customers where CustomerID = " & TextBox1.Text
cmdCust.Connection = SqlConnection1
SqlDataAdapter1.Fill(DataSet11, cmdCust.CommandText)
DataGrid1.DataSource = DataSet11

The problem is code refer to all item in table not condition input with user .

Else I want any search code .​

Please Anser with my question .​

 

[cjard]

read the DW1 linkin my signature