我想像数据库中插入数据 可是显示“/”应用程序中的服务器错误。
找不到请求的 .Net Framework 数据提供程序。可能没有安装。 好几台电脑都这样应该是代码的问题 代码如下
<%@ Page Language="C#" Debug="true" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml/DTD/xhtml-transitional.dtd">
<script runat="server">
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
SqlDataSource2.Insert();
lblMessage.Text="信息填写完整,正在注册!";
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>个人用户注册</title>
</head>
<body >
<form id="form1" runat="server">
<div>
<table width="40%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#33CCFF">
<tr bgcolor="#FFFFFF">
<td>
<asp:Label
id="label1"
text="身份证号:"
AssociatedControlid="txtName"
runat="server"/>
</td>
<td>
<asp:TextBox
id="txtName"
TextMode="SingleLine"
runat="server"/>
<asp:RequiredFieldValidator
id="reqSearchText"
ControlToValidate="txtName"
Text="(必填字段)"
runat="server"/>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<asp:Label
id="label2"
text="密码:"
AssociatedControlid="txtName1"
runat="server"/>
</td>
<td>
<asp:TextBox
id="txtName1"
TextMode="Password"
runat="server"/>
<asp:RequiredFieldValidator
id="reqSearchText1"
ControlToValidate="txtName1"
Text="(必填字段)"
runat="server"/>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<asp:Label
id="label3"
text="姓名:"
AssociatedControlid="txtName2"
runat="server"/>
</td>
<td>
<asp:TextBox
id="txtName2"
TextMode="SingleLine"
runat="server"/>
<asp:RequiredFieldValidator
id="reqSearchText2"
ControlToValidate="txtName2"
Text="(必填字段)"
runat="server"/>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<asp:Label
id="label4"
text="性别:"
AssociatedControlid="txtName3"
runat="server"/>
</td>
<td>
<asp:TextBox
id="txtName3"
TextMode="SingleLine"
runat="server"/>
<asp:RequiredFieldValidator
id="reqSearchText3"
ControlToValidate="txtName3"
Text="(必填字段)"
runat="server"/>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<asp:Label
id="label5"
text="年龄:"
AssociatedControlid="txtName4"
runat="server"/>
</td>
<td>
<asp:TextBox
id="txtName4"
TextMode="SingleLine"
runat="server"/>
<asp:RequiredFieldValidator
id="reqSearchText4"
ControlToValidate="txtName4"
Text="(必填字段)"
runat="server"/>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td>
<asp:Button
id="btnSubmit"
Text="注册"
OnClick="btnSubmit_Click"
runat="server"/>
</td>
</tr>
</table>
<hr/>
<asp:Label
id="lblMessage"
runat="server"/>
<asp:SqlDataSource
ID="SqlDataSource2"
ProviderName="System.Data.01eDb"
SelectCommand="SELECT * FROM 个人用户"
ConnectionString="Provider=Microsoft.Ace.OLEDB.12.0;
Data Source=|DataDirectory|五道口银行数据库.accdb"
InsertCommand="INSERT INTO 个人用户(身份证号,密码,姓名,性别,年龄) VALUES (@身份证号,@密码,@姓名,@性别,@年龄)"
Runat="server" >
<InsertParameters>
<asp:ControlParameter
Name="身份证号"
ControlID="txtName"
PropertyName="Text" />
<asp:ControlParameter
Name="密码"
ControlID="txtName1"
PropertyName="Text" />
<asp:ControlParameter
Name="姓名"
ControlID="txtName2"
PropertyName="Text" />
<asp:ControlParameter
Name="性别"
ControlID="txtName3"
PropertyName="Text" />
<asp:ControlParameter
Name="年龄"
ControlID="txtName4"
PropertyName="Text" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
求大神帮忙解答问题!
小的新手还没有C币。。。。