作者aming73 (aming)
看板C_Sharp
标题[问题] aspx database写法
时间Fri Dec 2 11:34:21 2005
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new
SqlConnection("server=172.17.7.16;uid=sa;pwd=;database=cs");
SqlDataAdapter cmd = new SqlDataAdapter("select * from cs95",conn);
DataSet ds = new DataSet();
cmd.Fill(ds,"cs95");
this.DataGrid1.DataSource= ds.Tables["cs95"];
this.DataGrid1.DataBind();
}
protected void sort (object obj, DataGridSortCommandEventArgs e){
SqlConnection conn = new
SqlConnection("server=172.17.7.16;uid=sa;pwd=;database=cs");
SqlDataAdapter cmd = new SqlDataAdapter("select * from cs95",conn);
DataSet ds = new DataSet();
cmd.Fill(ds,"cs95");
DataView dv = new DataView(ds.Tables["cs95"]);
dv.Sort=e.SortExpression.ToString();
this.DataGrid1.DataSource=dv;
this.DataGrid1.DataBind();
}
上面两段
黄色一样的部分,可以只写一次吗?
若只写一次要宣告在何处呢 是不是要写在web.asax里面呢?
谢谢高手指教
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 163.24.241.125
1F：推 tomex:写在web.config里，再用System.Configurxxx.AppSettings[] 12/02 17:36
2F：推 aming73:thank you 12/02 22:43