储存过程介绍及c#中的应用3

 有参数储存过程的调用

在数据库中创建一个存储过程，名为aaa：
CREATE PROCEDURE dbo.aaa
(@Number int) AS select * from 贴吧权限 where 论坛权限流水号 = @Number
GO

string connString = "Server = (local); Database = ChemChina; uid = sa; pwd = sa";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connString);
conn.Open();
System.Data.SqlClient.SqlCommand objCmd=conn.CreateCommand();
objCmd.CommandText="aaa";
objCmd.CommandType=CommandType.StoredProcedure ;
//-----准备stored procedure 的参数-------
objCmd.Parameters.Add("@Number",SqlDbType.Int);
objCmd.Parameters["@Number"].Value=1;
//-----执行存储过程---------------------- 
System.Data.SqlClient.SqlDataReader myReader=objCmd.ExecuteReader();
 if(myReader.Read())
  TextBox1.Text=myReader.GetValue(1).ToString();
  conn.Close();