OleDb + DataSet
Just a small code sample to show how to access an access database file with OleDb and the DataSet class.
Just hacked together and not for production use.
<%@ Page language="C#" %>
<script runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
System.Data.OleDb.OleDbConnection _conn =
new System.Data.OleDb.OleDbConnection();
_conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"DataSource=D:\WebRoot\data\data.mdb";
System.Data.OleDb.OleDbCommand _cmd = _conn.CreateCommand();
_cmd.CommandType = System.Data.CommandType.Text;
_cmd.CommandText = "SELECT Name FROM Users WHERE ID=1";
System.Data.OleDb.OleDbDataAdapter _adapter =
new System.Data.OleDb.OleDbDataAdapter();
_adapter.SelectCommand = _cmd;
System.Data.DataSet _dataset = new System.Data.DataSet();
_conn.Open();
_adapter.Fill(dataset, "UserTable");
_conn.Close();
if(_dataset.Tables["UserTable"].Rows.Count>0)
{
this.TextBox1.Text =
_dataset.Tables["UserTable"].Rows[0][0].ToString();
}
}
</script>
<html>
<body>
<form id="form1" runat="server">
<asp:TextBox id="TextBox1" runat="server" />
</form>
</body>
</html>