|
|
|
|
[我的ASP.net学习历程]DataAdapter操作之(二) |
|
|
|
作者：未知 来源：月光软件站 加入时间：2005-2-28 月光软件站 |
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
string dbPath = @"Data\dbTest.mdb";
string db = Server.MapPath (dbPath);
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + db;
string strSQL = "SELECT [CustomerID],[Address] FROM Customers";
DataSet ds = new DataSet();
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(strSQL,conn);
OleDbDataAdapter da = new OleDbDataAdapter();
//通过Command链接数据库操作
da.SelectCommand = cmd;
da.Fill(ds,"testMdb");
DataGrid1.DataSource = ds.Tables["testMdb"].DefaultView;
DataGrid1.DataBind();
}
|
|
相关文章：相关软件： |
|
本类阅读TOP10