存储过程的使用实例

数据库存数过程：

create proc [dbo].[ccgc]
@id int,
@name varchar(20) output
as 
begin
select * from tb_ceshi
set @name='输出参数'
end

　　

C#代码：

try
            {
                SqlConnection con = new SqlConnection("server=ANDY-PC;database=ceshi;uid=sa;pwd=123");
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandText = "ccgc";
                cmd.CommandType = CommandType.StoredProcedure;
                //普通参数
                cmd.Parameters.Add(new SqlParameter("@id",SqlDbType.Int));
                cmd.Parameters["@id"].Value = "1";
                //输出参数
                cmd.Parameters.Add(new SqlParameter("@name",SqlDbType.VarChar,20));
                cmd.Parameters["@name"].Direction = ParameterDirection.Output;

                SqlDataAdapter sda = new SqlDataAdapter();
                sda.SelectCommand = cmd;
                cmd.ExecuteNonQuery();
                //获取输出参数
                string name = cmd.Parameters["@name"].Value.ToString();

                DataSet ds = new DataSet();
                sda.Fill(ds);
                this.dataGridView1.DataSource = ds.Tables[0];
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }