sql select command where CustomerId LIKE textbox.text

Ryan Thomas

i'm attempting to use a select statement which retrieves products 'LIKE' textbox.text. However, i am given an error and cannot find a solution

private void buttonSearch_Click(object sender, EventArgs e)
{
if (radioButtonCustomerID.Checked == true)
{
try
{
sqlConnectionNW.Open();
sqlDataAdapterSearch.SelectCommand = "SELECT * FROM Customers WHERE (CustomerID LIKE'" + textBoxSearch.Text + "')";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlConnectionNW.Close();
}
}
the eror given is "cannot implicitly convert type 'string' to 'System.Data.SqlClient.SqlCommand"
Any help would be highly appreciated as it has stopped me dead in my tracks
thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

theLizard16y ago
If what I gave you worked (which I expect would have) then you would need to find out why your original code did not work.

I do not work with data bound controls ever, so I am not sure what needs to be done in regards to the use of data adapters.

Look at SqlCommand help and see how it is used with data adapters it may be very simple.
Ryan Thomas16y ago
the result of the search will fill a dataset which is bound to a datagrid view, all of which is set up, could the code you just gave me be altered to suit the sqlDataAdapter or would it be fine as it is?
thanks
theLizard16y ago
The string I gave is correct,

try the following.

      SqlConnection con = new SqlConnection();
      SqlCommand cmd = new SqlCommand("SELECT * FROM Customers WHERE CustomerID LIKE" + textBoxSearch.Text, con);
      cmd.ExecuteNonQuery();
Ryan Thomas16y ago
so the following should be correct:
"SELECT * FROM Customers WHERE CustomerID LIKE" + textBoxSearch.Text + "";
the same error comes up with this code too
theLizard16y ago
"SELECT * FROM Customers WHERE (CustomerID LIKE'" + textBoxSearch.Text + "')";

This is wrong

Remove ( and ) if textbox represents an int for id do not enclose in single quotes ' and '