Forum Moderators: open
connect to an ms access db
do a SQL query
get results
bind them in a datagrid
I have been able to do it in VB, thanks to 4guysfromrolla. But due to some environmental constraints, I need to do it with C#.
Can anyone help me?
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
public void Page_Load(Object sender, EventArgs e){
//'Create a connection string
mygrid.DataSource = CreateDataSource();
mygrid.DataBind();
}private DataSet CreateDataSource(){
string strConn;
strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=path-to-your-access-database.mdb;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter( "SELECT * FROM your-table-name", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);
return myDataSet;
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body>
<asp:datagrid id="mygrid" runat="server" />
</body>
</html>
