an SQL Search query using more than one condition

Question

my problem is that , i made a child form for searching , but i have problem in sql query and parameters , my code is

SqlConnection sc = new SqlConnection(
    "Data Source=MOHAMMED-PC;Initial Catalog=salessystem;Integrated Security=True");

SqlCommand command = new SqlCommand(
    "Select * from customers WHERE (docno = @doc) OR (NAME LIKE @name ) OR (salepoint = @salepoint)", sc);
DataTable dt = new DataTable();
command.Parameters.AddWithValue("@doc", doctxt.Text);
command.Parameters.Addwithvalue("@name", nametxt.Text);
command.Parameters.AddWithValue("@salepoint", salepointtxt.Text);
SqlDataAdapter sda = new SqlDataAdapter(command, sc);
sda.Fill(dt);
dataGridView1.DataSource = dt;

i have error in sql adapter command and in where clause command , any help ??

Please can you post the error message? – RB. Jan 23 '13 at 09:17 — RB., Jan 23 '13 at 09:17
What about checking data types, too. All test? – TomTom Jan 23 '13 at 09:18 — TomTom, Jan 23 '13 at 09:18

Tim Schmelter · Accepted Answer · 2013-01-23T09:57:31.997

4

Three things:

You have a typo on this line
```
command.Parameters.Addwithvalue("@name", nametxt.Text);
```
The method is AddWithValue (note the case difference)
The constructor of SqlDataAdapter takes the command but no connection then since the command already contains the connection, so this is correct:
```
SqlDataAdapter sda = new SqlDataAdapter(command);
```
Probably the most important last:

If you use LIKE you need to use the wild-cards %:

command.Parameters.AddWithValue("@name", string.Format("%{0}%",nametxt.Text);

edited Jan 23 '13 at 09:57

answered Jan 23 '13 at 09:21

Tim Schmelter

450,073
74
686
939

Makes you wonder if this is even the code that gave the OP an error. – Ravi Y Jan 23 '13 at 09:22
@ryadavilli: At least these are two compile time errors and he mentioned two errors(one at the "adapter command"). – Tim Schmelter Jan 23 '13 at 09:23
1

He should also not get any results from the LIKE clause where is he using the SQL `%` Wild card..? – MethodMan Jan 23 '13 at 09:24
@DJKRAZE: Yes, you're right. Edited my answer accordingly. Do you know how to format my answerso that the numbers are consecutively? – Tim Schmelter Jan 23 '13 at 09:27
i change the sql adapter command and i use the wild-cards , and its works fine, thank u very much – Mohammed AL Jakry Jan 23 '13 at 09:50

an SQL Search query using more than one condition

1 Answers1