WEB中存储过程在程序中的调用

create proc province_1 as  select * from province

 

public partial class WebForm4 : System.Web.UI.Page {         private string connstr = "data source=.;database=master;uid=sa;pwd=sadamu";         protected void Page_Load(object sender, EventArgs e)         {             BindData();         }         private void BindData()         {             DataTable dt = GetDataTable("province_1");             DataList1.DataSource = dt;             DataList1.DataBind();         }         private DataTable GetDataTable(string sqlstr)         {             SqlConnection conn = new SqlConnection(connstr);             conn.Open();             SqlCommand cmd = new SqlCommand(sqlstr, conn);             cmd.CommandType = CommandType.StoredProcedure;             SqlDataAdapter da = new SqlDataAdapter(cmd);             DataTable dt = new DataTable();             da.Fill(dt);             return dt;         }     }