I am programming using .net as front end and SQL server as back end and have the foll

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I am programming using .net as front end and SQL server as back end and have the foll

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Source Error:

Line 35:
Line 36: DataSet ds = new DataSet();
Line 37: da.Fill(ds);
Line 38: GridView1.DataSource = ds;
Line 39: GridView1.DataBind();

Source File: c:\Users\Shoaib\Desktop\Project\Admin.aspx.cs Line: 37

And the code is as given below:

Collapse | Copy Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;