asp.net使用存储过程

随便写几行

private string Result="";
SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
   SqlCommand cmd=new SqlCommand("GetMember",con);
   cmd.CommandType=CommandType.StoredProcedure;
   cmd.Parameters.Add("@memberid",SqlDbType.Int,4);
   cmd.Parameters["@memberid"].Value=TextBox1.Text.Trim();
   con.Open();
   SqlDataReader dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
   if(dr.Read())
   {
    for(int i=0; i<dr.FieldCount;i++)
    {
     Result+=dr[i].ToString()+"<br>";
    }
   }
   con.Close();