SqlCommand cmd=new SqlCommand("Insert into Student values(@StuName,@StuAge)" ,conn);
cmd.parameters.add("@StuName" ,stuName);
cmd.parameters.add("@StuAge" ,stuAge);
cmd.ExecuteNonQuery();
public static object SqlNull(object obj)
{
if(obj == null)
{
return DBNull.Value;
}
else
{
return obj;
}
}
SqlCommand cmd=new SqlCommand("Insert into Student values(@StuName,@StuAge)" ,conn);
cmd.parameters.add("@StuName" ,SqlNull(stuName));
cmd.parameters.add("@StuAge" ,SqlNull(stuAge));
cmd.ExecuteNonQuery();
public static object SqlNull(object obj)
{
if(obj == null || obj.ToString() == "")
{
return DBNull.Value;
}
else
{
return obj;
}
}
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@StuName", SqlNull(stuName)),
new SqlParameter("@StuAge", SqlNull(stuAge))
}
if(parm != null)
{
cmd.Parameters.AddRange(parm);
}
cmd.ExecuteNonQuery();
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有