Hi,
I am using this query to convert datetime column to date field and I get an error. When I try to select --Select-- in my dropdown I get this error.
**Error:Conversion failed when converting date and/or time from character string**
**Code Behind:**
protected void ddlDate_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlDate.SelectedItem.Text != "--Select--")
{
strDate = dddlDate.SelectedValue;
DataTable dtDate = DataRepository.GetDate(strDate);
gvDetails.DataSource = dtDate;
gvDetails.DataBind();
}
else
{
Response.Redirect("Details.aspx");
}
}
**I am using this in my DAL Layer**
public static DataTable GetDate(string strDate)
{
DataTable dt = new DataTable();
string strcon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(strcon))
{
conn.Open();
string strQuery = "select ID,Application_Name,Group,CONVERT(Date, Summary_Date) as Summary_Date,Comments from Application where Summary_Date <= '" + strDate + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
return dt;
}