error Sql query with datetime

Question

I got a error when I do the follow:

DateFrom has as datatype of datetime

enter image description here

My C# code:

string strQuery = "Select * FROM Agenda Where   DateFrom='" + Calendar1.SelectedDate.Date.Date + "' ";
SqlCommand command = new SqlCommand(strQuery, Global.myConn);
da = new SqlDataAdapter(command);
da.Fill(Global.dsAgenda, "Tabel");
ddlActivity.DataSource = Global.dtAgenda;
ddlActivity.DataBind();

Calendar1 type:

enter image description here

Error:

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

What format is Calendar1.SelectedDate.Date.Date in? Print it out and check. It's trying to cast it to a date (to compare) and failing. Please indicate what kind of database and version. SQL Server? — Nick.Mc
– Nick.Mc, Commented Apr 26, 2013 at 7:49

Carsten · Accepted Answer · 2013-04-26 07:56:29Z

4

You should prefer using parameters:

string strQuery = "SELECT * FROM Agenda WHERE DateFrom = @Date";
SqlCommand command = new SqlCommand(strQuery, Global.myConn);
command.Parameters.Add("@Date", SqlDbType.DateTime).Value = Calendar1.SelectedDate;

answered Apr 26, 2013 at 7:56

Carsten

11.7k7 gold badges43 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amit · Accepted Answer · 2013-04-26 07:50:17Z

1

Use this

 Convert(DateTime,Calendar1.SelectedDate.Date.Date,103)

answered Apr 26, 2013 at 7:50

Amit

15.4k8 gold badges49 silver badges69 bronze badges

1 Comment

Will_G Over a year ago

I use this: Convert.ToDateTime(Calendar1.SelectedDate.Date.Date) The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Collectives™ on Stack Overflow

error Sql query with datetime

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related