菜鸟问题，请各路大哥帮忙看看这段代码，谢谢！

chenbinggan19781013 2008-07-21 04:45:15

代码如下，注明：我的服务器不是本机的，而是网络上的一台服务器，错误是不能插出数据。郁闷，请帮帮忙，谢谢了

<script language="C#" runat="server">
void btnSubmit_Click(object Src, EventArgs E)
{
if (Page.IsValid)
{
string strSQL;
strSQL = "insert into UserInfo values(@UserName,@PassWord,@Email)";
SqlConnection cnn = new SqlConnection("Server=server;UID=sa;PWD=;DataBase=user");
SqlCommand cmm = new SqlCommand(strSQL, cnn);
cmm.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar, 255));
cmm.Parameters["@UserName"].Value = txtName.Text;
cmm.Parameters.Add(new SqlParameter("@PassWord", SqlDbType.VarChar, 255));
cmm.Parameters["@PassWord"].Value = txtName.Text;
cmm.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 255));
cmm.Parameters["@Email"].Value = txtName.Text;
cmm.Connection.Open();
try
{
cmm.ExecuteReader();
cmm.Connection.Close();
Response.Write("添加成功！");
}
catch
{
IblMsg.Style["color"]="red";
IblMsg.Text="插入数据出错";
}
}
}
</script>

...全文

131 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

yulitian 2008-07-22

打赏
举报

[Quote=引用 7 楼 chenbinggan19781013 的回复:]
出现这样的错误：資料行名稱或提供的數值數量與資料表定義不相符。
[/Quote]

就是说你插入的数据类型,和数据库定义的数据类型不一致.
是数据库问题,不一定是代码

chenbinggan19781013 2008-07-21

打赏
举报

这是全部的代码，请各位大哥帮帮忙，看看，我今天是第一次写代码，谢谢

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>资料登录注册系统</title>
<link rel="stylesheet" type="text/css" href="" />
<script language="C#" runat="server">
void btnSubmit_Click(object Src, EventArgs E)
{
if (Page.IsValid)
{
string strSQL;
strSQL = "insert into UserInfo values(@UserName,@PassWord,@Email)";
SqlConnection cnn = new SqlConnection("Server=server;UID=sa;PWD=;DataBase=user");
SqlCommand cmm = new SqlCommand(strSQL, cnn);
cmm.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar, 255));
cmm.Parameters["@UserName"].Value = txtName.Text;
cmm.Parameters.Add(new SqlParameter("@PassWord", SqlDbType.VarChar, 255));
cmm.Parameters["@PassWord"].Value = txtPassWord.Text;
cmm.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 255));
cmm.Parameters["@Email"].Value = txtEmail.Text;
cmm.Connection.Open();
try
{
cmm.ExecuteNonQuery();
cmm.Connection.Close();
Response.Write("添加成功！");
}
catch (Exception ee)
{
IblMsg.Style["color"] = "red";
IblMsg.Text = "插入数据出错" + ee.Message;
}
}
}
</script>
</head>
<body>
<h2 align="center">资料登录注册系统</h2>
<asp:Label ID="IblMsg" runat="server"/>
<form runat="server">
<table bgcolor="#eeeeee" cellpadding="10" align="center">
<tr>
<td>姓名：</td>
<td>
<asp:TextBox ID="txtName" MaxLength="20" runat="server"/>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvName" ControlToValidate="txtName" Display="Dynamic" InitialValue="" ErrorMessage="*" runat="server"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>密码：</td>
<td>
<asp:TextBox ID="txtPassWord" TextMode="Password" MaxLength="20" runat="server"/>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvPassWord" ControlToValidate="txtPassWord" Display="Dynamic" InitialValue="" runat="server" ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>确认密码：</td>
<td>
<asp:TextBox ID="txtRePassWord" TextMode="Password" MaxLength="20" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvRePassWord" ControlToValidate="txtRePassWord" Display="Dynamic" InitialValue="" runat="server" ErrorMessage="*"></asp:RequiredFieldValidator>
<asp:CompareValidator ID="cvRePassWord" ControlToValidate="txtRePassWord" ControlToCompare="txtPassWord" Display="Dynamic" runat="server" ErrorMessage="密码确认错误，请注意字母大小写！"></asp:CompareValidator>
</td>
</tr>
<tr>
<td>电子邮件：</td>
<td>
<asp:TextBox ID="txtEmail" MaxLength="60" runat="server" />
</td>
<td>
<asp:RequiredFieldValidator ID="rvfMail" ControlToValidate="txtEmail" Display="Dynamic" InitialValue="" runat="server" ErrorMessage="*"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="revEmail" ControlToValidate="txtEmail" Display="Dynamic" runat="server" ErrorMessage="无效电子邮件地址！" ValidationExpression="^[\w-]+@[\w-]+\.(com|net|org|edu|mil)$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Button ID="btnSubmit" OnClick="btnSubmit_Click" Class="mybtn" runat="server" Text="提交" />
</td>
</tr>
</table>
</form>
</body>
</html>

chenbinggan19781013 2008-07-21