得到错误使用时日期搜索 [英] Getting Error When use Date to Search

问题描述

        cmdDateReceivingStock = new SqlCommand("Select Distinct Date FROM 
        OrderDetails WHERE item_Received ='No'", conStock);

        SqlDataAdapter da = new SqlDataAdapter(cmdDateReceivingStock);
        DataSet ds = new DataSet();
        da.Fill(ds);

        ddlOrderDate.DataTextFormatString = "{0:dd-MM-yyyy}";
        ddlOrderDate.DataSource = ds;
        ddlOrderDate.DataTextField = "Date";
        ddlOrderDate.DataBind();

在我的成功转换日起DropDownList的，但我得到这个错误从字符串转换日期和/或时间时，转换失败。当我使用的日期从数据库中检索数据。

After I success convert the date into dropdownlist,but I getting this error"Conversion failed when converting date and/or time from character string." when I use the date to retrieve data from database.

推荐答案

您的SELECT语句是好的，你要修改日期格式在DDL：

Your SELECT statement is fine, you have to modify the date format in your ddl:

ddlOrderDate.DataTextFormatString = "{0:dd-MM-yyyy}";

这篇关于得到错误使用时日期搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！