SqlCommand 时间参数问题
没有错误提示,从数据库提不出应该有的数据,即应该DataView.Count>0,但是DataView.Count=0,why?
String c_sql1="SELECT * FROM packing_mx_total_zcd_color where zcd='"+c_zcd+"' and out_date<=@date";
String c_connect=Session["s_connect"].ToString();
SqlConnection mySQLConnection = new SqlConnection(c_connect);
SqlDataAdapter myCommandassorted = new SqlDataAdapter();
SqlCommand selectCMD = new SqlCommand(c_sql1, mySQLConnection);
myCommandassorted.SelectCommand = selectCMD;
selectCMD.Parameters.Add("@date", SqlDbType.DateTime).Value = Convert.ToDateTime(c_date);
DataSet dsassorted = new DataSet();
myCommandassorted.Fill(dsassorted, "assorted");
DataView assortedView=new DataView(dsassorted.Tables["assorted"]);