编程语言

img bgu

[我的ASP.net学习历程]DataAdapter操作之(一)

发表于2004/9/24 8:54:00  919人阅读

分类: [My ASP/ASP.net(C#)]

  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);
OleDbDataAdapter da = new OleDbDataAdapter(strSQL,conn);

//通过Connection链接数据库操作
da.Fill(ds,"testMdb");

DataGrid1.DataSource = ds.Tables["testMdb"].DefaultView;
DataGrid1.DataBind();

}
阅读全文
0 0

相关文章推荐

img
取 消
img