日期型插入數據庫SQLSERVER
string sqlStr = "insert into tzhs_x values(@dateb)";
SqlCommand com = new SqlCommand(sqlStr,con);
SqlParameter bdate = new SqlParameter("@bdate",SqlDbType.DateTime,8);
bdate.Value = this.txtyear.Text;
com.Parameters.Add(bdate);
如果為空的時候就會類型出錯,為空的時候我這麽插入