[我的ASP.net学习历程]数据库操作(一)

<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>

<script language="C#" runat="server">

void Page_Load()

{

string DB_name = "dbTest.mdb";

string DB_path = Server.MapPath(DB_name);

string SQL = "SELECT [CategoryID],[CategoryName] FROM [Categories]";

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" + DB_path ;

//建立OleDbConnection

System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);

//建立OleDbCommand

System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();

dbCommand.CommandText = SQL;

dbCommand.Connection = dbConnection;

//建立DataSet

System.Data.DataSet dbSet = new System.Data.DataSet();

//建立OleDbDataAdapter

System.Data.IDbDataAdapter dbAdapter = new System.Data.OleDb.OleDbDataAdapter();

dbAdapter.SelectCommand = dbCommand; //选择OleDbCommand

dbAdapter.Fill(dbSet); //填充DataSet

//DataGrid控件操作

DataGrid1.DataSource = dbSet; //数据源

DataGrid1.DataBind(); //压入数据

}

</script>

<form runat="server">

<asp:datagrid ID="DataGrid1" runat="server"/>

</form>