RadDatePicker with SqlQuery gives conversion error

[Sucheta Patil]

hi
Below is my sql query whose output I intend to bind to RadGrid1.
But I get error on DateTime field ExpectedDate which is a RadDatePicker.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime

My code is

string strSql = "Select 'Visitor''s Name'=VisitorsName,'Organisation'=VisitorsOrg ,
'Due at' =Arriving_at_hr+':'+Arriving_at_mm, 'Visiting'=Name, Faculty=Short_name , School=School ,
'Call Ext'=Extension,'Meeting room'=RoomNo,'Send to Room'=Send_to_room,Comments
from tblVisitors,tblservice where tblvisitors.Division=tblService.Faculty_Name and Centre='" + lstCentre.SelectedItem.Value + "'
and ExpectedDate = convert(varchar(50),'" + txtOnDate.SelectedDate.Value + "', 101) Order by Name";

          

Any quick help is appreciable!!!
I had to come up with this coz no one replied me for
http://www.telerik.com/community/forums/aspnet-ajax/general-discussions/linq-where-clause-in-aspx-with-datetime-does-not-work.aspx

Please this is not solved either!!!!
S

[Radoslav]

Hello Sucheta,

To achieve the desired functionality you could try using the following approach:
Remove the DateTime.Parse from LinqDataSource's Where clause and remove the WhereParameters:

<asp:LinqDataSource ID="LinqVisitors" runat="server" ContextTypeName="CWC.Staffnet.Forms.StaffnetDataContext" TableName="tblVisitors"
Where="Centre == @Centre && ExpectedDate == @ExpectedDate" onselecting="LinqVisitors_Selecting">
</asp:LinqDataSource>

On txtOnDate_SelectedDateChanged event handler add explicitly Parameter to the LinqVisitors.WhereParameters with DefaultValue equals to txtOnDate.SelectedDate:

void txtOnDate_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
{
   Parameter p = new Parameter();
   p.Name = "ExpectedDate";
   p.Type=TypeCode.DateTime;
   p.DefaultValue = txtOnDate.SelectedDate.ToString();
   LinqVisitors.WhereParameters.Add(p);
}

Additionally I am sending you a simple example which demonstrates the described approach. Please check it out and let me know if it helps you.

Kind regards,
Radoslav
the Telerik team

[Sucheta Patil]

Hi Radoslav,
        Thanks for the help.I figured it out myself as I had to submit it quickly.
Thanks anyways,

Sucheta