private void Button5_Click(object sender, System.EventArgs e)
{
string strconn= ConfigurationSettings.AppSettings["vote"];
//连接本地计算机的WMS数据库
SqlConnection cn1= new SqlConnection (strconn);
cn1.Open ();
SqlCommand cm1=new SqlCommand ("TimeAdd",cn1);
cm1.CommandType =CommandType.StoredProcedure ;
cm1.Parameters .Add ("@mintime",SqlDbType.DateTime );
cm1.Parameters .Add ("@maxtime",SqlDbType.DateTime );
cm1.Parameters ["@mintime"].Value =mintime.Text .ToString ();
cm1.Parameters ["@maxtime"].Value =maxtime.Text. .ToString ();
cm1.ExecuteNonQuery ();
cn1.Close ();
}
{
string strconn= ConfigurationSettings.AppSettings["vote"];
//连接本地计算机的WMS数据库
SqlConnection cn1= new SqlConnection (strconn);
cn1.Open ();
SqlCommand cm1=new SqlCommand ("TimeAdd",cn1);
cm1.CommandType =CommandType.StoredProcedure ;
cm1.Parameters .Add ("@mintime",SqlDbType.DateTime );
cm1.Parameters .Add ("@maxtime",SqlDbType.DateTime );
cm1.Parameters ["@mintime"].Value =mintime.Text .ToString ();
cm1.Parameters ["@maxtime"].Value =maxtime.Text. .ToString ();
cm1.ExecuteNonQuery ();
cn1.Close ();
}
cm1.Parameters ["@maxtime"].Value = DateTime.Parse(maxtime.Text.ToString());
cm1.Parameters ["@mintime"].Value =mintime.Text.ToString();
cm1.Parameters ["@maxtime"].Value =maxtime.Text.ToString();
改成这样
if(mintime.Text!="")
{
cm1.Parameters ["@mintime"].Value =Convert.ToDateTime(mintime.Text);
}
else
{
cm1.Parameters ["@mintime"].Value =System.DBNull.Value;
}
if(maxtime.Text!="")
{
cm1.Parameters ["@maxtime"].Value =Convert.ToDateTime(maxtime.Text);
}
else
{
cm1.Parameters ["@maxtime"].Value =System.DBNull.Value;
}