数据无法输入数据库
我用存储过程插入数据
存储过程为
create procedure adad(@num int,@ad varchar,@cod varchar,@nam varchar,@man int)
as
insert
into ad(员工号,用户名,密码,姓名,经理)
values(@num,@ad,@cod,@nam,@man);
程序代码为
SqlConnection con = new SqlConnection("server=.;database=supermarket;trusted_connection=true");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "adad";
SqlParameter[] par =
{
new SqlParameter("@num",this.label5.Text),
new SqlParameter("@ad",this.textBox1.Text),
new SqlParameter("@cod",this.textBox2.Text),
new SqlParameter("@nam",this.textBox4.Text),
new SqlParameter("@man",flag)
};
foreach (SqlParameter parms in par)
{
cmd.Parameters.Add(parms);
}
cmd.ExecuteNonQuery();
可是new SqlParameter("@nam",this.textBox4.Text),处的值插入表后为空,换flag就能输入,@nam处的数据类型为varchar
该怎么改?