A very simple instance code to connect to an Access database, a friend in Need can refer to
Index.aspx
Copy Code code as follows:
<%@ Page language= "C #"%>
<%@ import namespace= "System.Data"%>
<%@ import namespace= "Syst" Em. Data.oledb "%>
<script runat=" Server "
//Insert page code here
& nbsp
void Page_Load () {
string db=@ "database/ Data.mdb ";
string connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath (db) + ";";
string sqlcmd= CREATE TABLE Ieb_webs (ID identity Primary Key,title varchar (255) Default Null) ";
OleDbConnection conn=new OleDbConnection (CONNSTR);
Conn. Open ();
OleDbCommand olecmd=new OleDbCommand (sqlcmd,conn);
olecmd.executenonquery (); Execute SQL command
Response.Write ("Data table build!") ");
}
Conn. Close ();
Conn=null;
Olecmd=null;
}
</script>
<body>
< Form method= "POST" runat= "server"
<!--Insert content here--
</form>
</body>