ALTER PROCEDURE [dbo].[SmsServer_Save]
(
@Serial int,
@User varchar(15),
@Mobile varchar(11),
@Name varchar(20),
@SmsClass varchar(200),
@AreaLocation varchar(200),
@IndustryClass varchar(200),
@RegDate datetime,
@RegIp varchar(20),
@ServerBegin datetime,
@ServerEnd datetime,
@level smallint,
@Operator varchar(15),
@PostDate datetime
)
我要向数据库插入值,只插2列Mobile和Name,其他列都不插入数值,但是表里都有非空约束,在实体类上赋值怎么写?
SmsServer smsserver = new SmsServer();
smsserver.User = "";
smsserver.Mobile = this.txtMobile.Text;
smsserver.Name = this.txtName.Text;
smsserver.SmsClass = "";
这样双引号行吗?还有datetime的类型怎么赋值啊?
我不能去数据库改列给他们的默认值,因为我没有权限,改怎么办啊?
string类型smsserver.User = ""; 这样写可以吗?
|