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();
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
Pravesh Singh
16-Dec-2013Try this in your sql query.
cmdDateReceivingStock = new SqlCommand("Select Distinct CONVERT(VARCHAR,Date,103) FROM
OrderDetails WHERE item_Received ='No'", conStock);