存储过程
CREATE procedure adad(@num int,@ad char,@cod varchar,@nam text,@man int)
as
insert
into ad(员工号,用户名,密码,姓名,经理)
values(@num,@ad,@cod,@nam,@man);
各变量数据类型依次为int 4,char 50,varchar 50,text 16.int 4
代码为
SqlConnection con = new SqlConnection("server=.;database=superet;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();
运行后@ad,this.textBox1.Text,@cod,this.textBox2.Text均只输入了第一个字符,怎么改?
CREATE procedure adad(@num int,@ad char,@cod varchar,@nam text,@man int)
as
insert
into ad(员工号,用户名,密码,姓名,经理)
values(@num,@ad,@cod,@nam,@man);
各变量数据类型依次为int 4,char 50,varchar 50,text 16.int 4
代码为
SqlConnection con = new SqlConnection("server=.;database=superet;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();
运行后@ad,this.textBox1.Text,@cod,this.textBox2.Text均只输入了第一个字符,怎么改?
@ad char,--1
@cod varchar,--2
@nam text,
@man int
)
--try
在以上两个位置指定长度 如char(100)