|
|
|
|
[我的ASP.net学习历程]DataBase Settion(5) |
|
|
|
作者：未知 来源：月光软件站 加入时间：2005-2-28 月光软件站 |
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
// 写法一:
// string connectionString = "SERVER=172.24.17.134;USER ID=sa;PWD=testPass;DATABASE=TestDb";
// 写法二:
// string connectionString = "SERVER=HD-SERVER;USER ID=sa;PWD=testPass;DATABASE=TestDb";
// 写法三:
// string connectionString = "SERVER=(local);USER ID=sa;PWD=testPass;DATABASE=TestDb";
string connectionString = "SERVER=(local);USER ID=sa;PWD=testPass;DATABASE=TestDb";
string strSQL = "SELECT * FROM Table_1";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(strSQL,conn);
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataGrid1.DataSource = dr;
DataGrid1.DataBind();
cmd.Dispose();
dr.Close();
cmd.Connection.Close();
cmd.Connection.Dispose();
}
|
|
相关文章：相关软件： |
|
本类阅读TOP10