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

王朝asp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

<%@ 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>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航