C#中调用SQL存储过程(带输入参数的例子)

               SqlConnection conn = pbvar.getconn();//调味用公共类

                conn.Open();

                SqlCommand sqlcmd =new SqlCommand("xt_Company_insert", conn);//调用sql中的存储过程(xt_Company_insert)带四个输入参数

                sqlcmd.CommandType = CommandType.StoredProcedure; //设置命令的类型为存储过程

                sqlcmd.Parameters.Add("@CompanyName", SqlDbType.VarChar, 50);//设置存储过程的参数据及参数的大小

                sqlcmd.Parameters.Add("@CompanyTelephone", SqlDbType.VarChar, 20);//设置存储过程的参数据及参数的大小

                sqlcmd.Parameters.Add("@CompanyMail", SqlDbType.VarChar, 30);//设置存储过程的参数据及参数的大小

                sqlcmd.Parameters.Add("@CompanyAddress", SqlDbType.VarChar, 50);//设置存储过程的参数据及参数的大小

                sqlcmd.Parameters["@CompanyName"].Value = txbcompanyname.Text.Trim();//给参数赋值

                sqlcmd.Parameters["@CompanyTelephone"].Value = txbtelephome.Text.Trim();//给参数赋值

                sqlcmd.Parameters["@CompanyMail"].Value = txbaddress.Text.Trim();//给参数赋值

                sqlcmd.Parameters["@CompanyAddress"].Value = txbaddress.Text.Trim();//给参数赋值

                sqlcmd.ExecuteNonQuery();//执行存储过程

                MessageBox.Show("保存成功！","提示",MessageBoxButtons.OK ,MessageBoxIcon.Information);

                this.Close();