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; } } |