用asp.net如何访问access数据库,我这里做了个插入测试,但是插不进去?
gsoft 2006-10-12 05:36:27 <HTML>
<HEAD>
<title></title>
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.SqlClient" %>
<SCRIPT language="C#" Runat="Server">
public string myConnstring="Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:E:/Inetpub/wwwroot/WebApplication2/test.mdb;";
SqlConnection MyConnection;
public void Page_Load(Object src,EventArgs e)
{
//用户提交数据
}
public void submit_Click(Object src,EventArgs e)
{
string username1 = Request.Form["username"];
string address1 = Request.Form["address"];
string school1 = Request.Form["shool"];
string strInsert="insert into aspcn(username,address,school) values('"+username1+"','"+address1+"','"+school1+"')";
//开始联结
try
{
MyConnection = new SqlConnection(myConnstring);
SqlCommand MyCommand = new SqlCommand(strInsert,MyConnection);
MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
Info.Text="数据已经保存";
}
catch(Exception ee)
{
Info.Text="发生错误:"+ee.Message;
}
}
</SCRIPT>
</HEAD>
<body>
<form runat="server">
<asp:label id="Info" Runat="server"></asp:label>
<asp:TextBox ID="username" Runat="server"></asp:TextBox>
<asp:TextBox ID="address" Runat="server"></asp:TextBox>
<asp:TextBox ID="school" Runat="server"></asp:TextBox>
<asp:button id="button1" text="button1" Runat="server" type="submit"></asp:button>
</form>
</body>
</HTML>
请大家指点