OleDb + DataReader
Just a small code sample to show how to access an access database file with OleDb and the DataReader 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";
_conn.Open();
System.Data.OleDb.OleDbDataReader _reader = cmd.ExecuteReader();
if(_reader.Read())
{
this.TextBox1.Text = _reader.GetString(0);
}
_reader.Close();
_conn.Close();
}
</script>
<html>
<body>
<form id="form1" runat="server">
<asp:TextBox id="TextBox1" runat="server" />
</form>
</body>
</html>