> 
- Home Page
- > Script C#
- > Script C# Database
- > Access
Access - << VB.NET VERSION >>
Connect to Access
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
OleDbConnection dbConn;
OleDbDataAdapter myAdapter;
string sqlCmd;
string strConn;
DataSet oDataSet = new DataSet();
strConn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath("database/utenti.mdb") + ";" +
"Persist Security Info=False";
sqlCmd =
"SELECT " +
" nome, " +
" cognome, " +
" email " +
" FROM utenti";
dbConn = new OleDbConnection(strConn);
myAdapter = new OleDbDataAdapter(sqlCmd, dbConn);
myAdapter.Fill(oDataSet, "utenti");
myDatagrid.DataSource = oDataSet.Tables["utenti"].DefaultView;
myDatagrid.DataBind();
}
</script>
<html>
<body>
<asp:DataGrid id="myDatagrid" runat="server" />
</body>
</html>
