About dateTimePicker problem

[miss YY]

string from,to; from=this.dateTimePicker1.Value.ToShortDateString(); to=this.dateTimePicker2.Value.ToShortDateString(); string str="select * from Furn_Info where Time between ‘"+from+"’ and ‘"+to+"’"; but it do not work as i think ,i'm use data SQl2000 please show me how can i do

[avigodse]

Hi, there are many reasons behind not getting resultset. some of them can be your datepicker value is not in correct date format as SQL expects, or check your system date formats, or just format date value before adding to query.

Avinash S. Godse

[Lost User]

Try this:

from=this.dateTimePicker1.Value.ToString("yyyy/MM/dd");
to=this.dateTimePicker2.Value.ToString("yyyy/MM/dd");

[ScottM1]

miss YY wrote:

string str="select * from Furn_Info where Time between ‘"+from+"’ and ‘"+to+"’";

Rather parameterize your queries like so: cmd.CommandText = "select * from Furn_Info where Time between @from and @to"; cmd.Parameters.AddWithValue("@from", from.ToString("yyyyMMdd")); cmd.Parameters.AddWithValue("@to", to.ToString("yyyyMMdd"));

[PIEBALDconsult]

Yes parameterize, but don't make the dates into strings.

[ScottM1]

Why not? How would you do it, just put the DateTime object as the parameter value?

[PIEBALDconsult]

ScottM1 wrote:

put the DateTime object as the parameter value?

Of course.

[zingoraa]

Avinash, Same names. Yet you could have given this answer with example.

modified on Friday, April 8, 2011 11:14 AM