数据库存数过程:
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);
}