i have search code but ther is error popping after debugging about an error showing{ Incorrect syntax near ','.}

Question

0.00/5 (No votes)

See more:

//i am trying to give an output of data showing that if a user enters a name selects the date to his desired date output must be showing name records from date selected her is my code

C#

private void button5_Click(object sender, EventArgs e)
       {

           con = new SqlConnection(@"Data Source=abbas-PC\SQLEXPRESS;Initial Catalog=EREGISTRY;Integrated Security=True");
           ds = new DataSet();
           cmd = new SqlCommand("select * from REGISTRY where CUSTUMER=@CUSTUMER,DATE=@DATE",con);
           cmd.Parameters.Add("CUSTUMER", SqlDbType.NVarChar, 40).Value = textBox6.Text;
           //cmd = new SqlCommand("select * from REGISTRY where DATE=@DATE", con);
           cmd.Parameters.Add("DATE", SqlDbType.NVarChar, 20).Value = dateTimePicker2.Value;
           da = new SqlDataAdapter(cmd);

           con.Open();
           da.Fill(ds, "reg");
           con.Close();


           dataGridView1.DataSource = ds.Tables[0];

Posted 27-Jul-12 14:18pm

adnanhakim110

Add a Solution

3 solutions

Solution 3

C#

private void button5_Click(object sender, EventArgs e)
       {

           con = new SqlConnection(@"Data Source=abbas-PC\SQLEXPRESS;Initial Catalog=EREGISTRY;Integrated Security=True");
           ds = new DataSet();
           cmd = new SqlCommand("select * from REGISTRY where CUSTUMER=@CUSTUMER and DATE=@DATE",con);
           cmd.Parameters.Add("CUSTUMER", SqlDbType.NVarChar, 40).Value = textBox6.Text;
           //cmd = new SqlCommand("select * from REGISTRY where DATE=@DATE", con);
           cmd.Parameters.Add("DATE", SqlDbType.NVarChar, 20).Value = dateTimePicker2.Value;
           da = new SqlDataAdapter(cmd);

           con.Open();
           da.Fill(ds, "reg");
           con.Close();


           dataGridView1.DataSource = ds.Tables[0];

Posted 27-Jul-12 19:24pm

AshishChaudha

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

StianSandberg · Accepted Answer · 2012-07-27T14:24:00

Solution 1

You can't write "CUSTUMER=@CUSTUMER,DATE=@DATE".

You should write "CUSTUMER=@CUSTUMER AND DATE=@DATE"

Another thing as that you should treat dates as Date. Not convert it to strings.

Posted 27-Jul-12 14:24pm

StianSandberg

Comments

[no name] 27-Jul-12 21:21pm

5. And use using blocks.

StianSandberg 27-Jul-12 21:34pm

using(){thank you..}

AshishChaudha 28-Jul-12 1:24am

my 5!

Prosan · Accepted Answer · 2012-07-27T18:57:00

Solution 2

correct this line in query

C#

cmd = new SqlCommand("select * from REGISTRY where CUSTUMER=@CUSTUMER,DATE=@DATE",con);

to

C#

cmd = new SqlCommand("select * from REGISTRY where CUSTUMER=@CUSTUMER and DATE=@DATE",con);

in place of , use and

Posted 27-Jul-12 18:57pm

Prosan