using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["pub"].ToString()))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn; SqlParameter[] parameters = {
new SqlParameter("@Ncode", SqlDbType.Char,16),
new SqlParameter("@name", SqlDbType.Char,50),
new SqlParameter("@pcode", SqlDbType.Char,20),
new SqlParameter("@flag", SqlDbType.Char,2)};
parameters[0].Value = textBox1.Text;
parameters[1].Value = textBox2.Text;
parameters[2].Value = textBox3.Text;
parameters[3].Value = textBox4.Text;
cmd.CommandText = "UP_Name_ADD";
cmd.ExecuteNonQuery();
}到红色部分就错了,我记得sql2005是这样的,sql2000就不可以呢两种的区别在哪里
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn; SqlParameter[] parameters = {
new SqlParameter("@Ncode", SqlDbType.Char,16),
new SqlParameter("@name", SqlDbType.Char,50),
new SqlParameter("@pcode", SqlDbType.Char,20),
new SqlParameter("@flag", SqlDbType.Char,2)};
parameters[0].Value = textBox1.Text;
parameters[1].Value = textBox2.Text;
parameters[2].Value = textBox3.Text;
parameters[3].Value = textBox4.Text;
cmd.CommandText = "UP_Name_ADD";
cmd.ExecuteNonQuery();
}到红色部分就错了,我记得sql2005是这样的,sql2000就不可以呢两种的区别在哪里
sql2000也可以使用,我用过,没问题