可以写个SP,在SP中处理更方便而且执行效率又高, Create sp_test(@name varchar(100),@sj varchar(50)) as declare @tempsj as datetime if ltrim(rtrim(@sj))=‘’ set @tempsj=null else set @tempsj=convert(datatime,ltrim(rtrim(@sj))) insert into a(name,sj) values ((@name ,@tempsj) return
DataTime sj;
if(czsj.Text!="")
{
sj=Convert.ToDataTime(czsj.Text);
}最后需要用insert into a(name,sj) values ('"+name+"','"+sj+"')写入数据库
DataTime sj;
if(czsj.Text!="")
{
sj=Convert.ToDataTime(czsj.Text);
sql = insert into a(name,sj) values ('"+name+"','"+sj+"');
}
else
{
sql = insert into a(name) values ('"+name+"');
}
怎么用啊。 ?
insert into a(name,sj) values ('"+name+"',"+sj+")
然后sj变量的取值改为如下:
sj = this.TextBox1.Text == ""?"null":"'" + this.TextBox1.Text + "'";
如此即可实现当空时写入null,不空时写入值.
Create sp_test(@name varchar(100),@sj varchar(50))
as
declare @tempsj as datetime
if ltrim(rtrim(@sj))=‘’
set @tempsj=null
else
set @tempsj=convert(datatime,ltrim(rtrim(@sj))) insert into a(name,sj) values ((@name ,@tempsj)
return