help me to search by date in the select statmen'

Question

0.00/5 (No votes)

See more:

See more: Code Hi,

I've created a program in C#, when I search by date an error is displayed

I need to search by date in SQL Server, can I do that? Or can I use the convert function in the SELECT statement

Please help me

the table is outlaid the column date_outlaid
the erorr display
is
syntax erorr convertingthe varchar value aug20 2011 12:00 Am to column of data type int
the code is

C#

private void display_outliad_f(string x)
        {
            //creat adabter to execute the query
            SqlDataAdapter ad = new SqlDataAdapter(x, con1);
            //create comand buillder
            SqlCommandBuilder cBulider = new SqlCommandBuilder(ad);
            //create data table to hold the result query
            DataTable dTable = new DataTable();
            //fill the data table
            ad.Fill(dTable);
            //to sycron between table and grv
            BindingSource Bsource = new BindingSource();
            //set bsouce to the datasource
            Bsource.DataSource = dTable;
            dataGridView1.DataSource = Bsource;
        }

the statmants ask is

C#

private void textBox4_TextChanged(object sender, EventArgs e)
        {
         display_outliad_f("select * from outlaid where date_outlaid="+date );
        }

help me please to chang this code

Posted 27-Oct-11 22:53pm

abuhmamm

Updated 27-Oct-11 22:54pm

Dave Kerr

v3

Add a Solution

4 solutions

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)

Dave Kerr · Answer 1 · 2011-10-27T22:56:00

Solution 1

Try this:

C#

private void textBox4_TextChanged(object sender, EventArgs e)
        {
         display_outliad_f("select * from outlaid where date_outlaid=\""+date.ToToShortDateString() + """ );
        }

Posted 27-Oct-11 22:56pm

Dave Kerr

Updated 27-Oct-11 23:23pm

v2

Comments

Mehdi Gholam 28-Oct-11 5:24am

Fixed the string deliminator

abuhmamm 28-Oct-11 18:39pm

when applied this error

P.Salini · Answer 2 · 2011-10-27T23:01:00

Solution 2

The error says the cannot convert varchar to int.

What is the datatype of date_outlaid column

Posted 27-Oct-11 23:01pm

P.Salini

OriginalGriff · Answer 3 · 2011-10-27T23:02:00

Just to add to what DaveKerr said: SQL server always wants dates in ISO format: yyyy-MM-dd, so the solution he gave may help, but probably will need changes, as the ToShortDateString method returns the date in the format appropriate to your current locale.

Instead, consider using

date.ToString("yyyy-MM-dd")

Or, (preferably) using it as a SQL Parameter instead - this would mean changing your display_outliad_f method quite a bit, but is a very good idea in the long run.

All of this may still not do what you want - it assumes that you are storing date_outlaid as a DateTime in your SQL database.

Bala Selvanayagam · Answer 4 · 2011-10-27T23:13:00

Solution 4

try this

C#

private void textBox4_TextChanged(object sender, EventArgs e)
        {
         display_outliad_f("select * from outlaid where date_outlaid='"+date.ToString("yyyy-MMM-dd") + "'" );
        }

Posted 27-Oct-11 23:13pm

Bala Selvanayagam

Updated 27-Oct-11 23:17pm

v2