| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 3809 人关注过本帖
标题:【求助】vs20008调试时出现“插入错误: 列名或所提供值的数目与表定义不匹配 ...
取消只看楼主 加入收藏
surpassyouuo
Rank: 1
等 级:新手上路
帖 子:10
专家分:0
注 册:2011-10-26
结帖率:80%
收藏
已结贴  问题点数:10 回复次数:2 
【求助】vs20008调试时出现“插入错误: 列名或所提供值的数目与表定义不匹配。”
初学中……做一个注册页面,注册时点击“注册”,出现如下所示的错误!~
 插入错误: 列名或所提供值的数目与表定义不匹配。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 插入错误: 列名或所提供值的数目与表定义不匹配。

源错误:

行 70:                 SqlCommand com = new SqlCommand(sqlIns, con);
行 71:                 //判断ExecuteNonQuery方法返回的参数是否大于0,大于0表示注册成功
行 72:                 if (com.ExecuteNonQuery() > 0)
行 73:                 {
行 74:                     RegisterStartupScript("", "<script>alert('注册成功!')</script>");


源文件: f:\dengyiweb\myweb\Register.aspx.cs    行: 72

堆栈跟踪:
[SqlException (0x80131904): 插入错误: 列名或所提供值的数目与表定义不匹配。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950954
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846939
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Register.btnRegister_Click(Object sender, EventArgs e) in f:\dengyiweb\myweb\Register.aspx.cs:72
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565


其前台部分代码如下:
    <table width="902" height="369" border="0" cellpadding="0" cellspacing="0" background="images/zc_06.jpg">
        <tr>
            <td align="center" valign="top">
                <table width="80%" height="352" border="0" cellpadding="0" cellspacing="1" bgcolor="#c0c4c3">
                    <tr>
                        <td height="30" colspan="2" align="left" bgcolor="#30536f" class="a">
                            用户注册
                        </td>
                    </tr>
                    <tr>
                        <td width="71%" height="320" align="center" bgcolor="#faf6f1">
                        
                        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                        <ContentTemplate>
                            <table border="0" cellpadding="0" cellspacing="0" style="width: 477px; height: 48px;">
                                <tr>
                                    <td style="width: 88px; height: 24px; text-align: right">
                                        <span style="font-size: 10pt">会 员 名: </span>
                                    </td>
                                    <td style="height: 24px; text-align: left; width: 509px;">
                                        <label>
                                        <asp:TextBox ID="txtName" runat="server" AutoPostBack="True" onFocus="tName();"
                                            OnTextChanged="txtName_TextChanged" Width="128px"></asp:TextBox>
                                        <span class="STYLE1">**</span>
                                        <asp:Label ID="labUser" runat="server" Font-Size="12px" Text="只能输入数字、字母、下划线"
                                            Width="159px"></asp:Label>
                                        <asp:Label ID="labIsName" runat="server" Font-Size="12px"></asp:Label>
                                        </label>
                                    </td>
                                </tr>
                            </table>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                        
                            <table width="90%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                    <td width="19%" height="25" align="right">
                                        &nbsp;</td>
                                    <td width="38%">
                                        <label>
                                            &nbsp;</label>
                                    </td>
                                    <td width="43%" align="left">
                                        &nbsp;</td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        密 码:
                                    </td>
                                    <td>
                                        <label>
                                            <asp:TextBox ID="txtPass" runat="server" onFocus="tPass();" onchange="passHint()"
                                                TextMode="Password" Width="128px"></asp:TextBox>&nbsp;</label>
                                    </td>
                                    <td align="left">
                                        <span class="STYLE1">*<table id="tab" border="0" cellpadding="0" cellspacing="0"
                                            style="width: 151px">
                                            <tr>
                                                <td style="width: 276px">
                                                    <span style="font-size: 10pt">密码强度:</span>
                                                </td>
                                                <td id="r" style="width: 100px" align="center">
                                                    <asp:Label ID="labEbb" runat="server" Text="弱" Width="18px" Font-Size="12px"
                                                        ForeColor="#F2EFE7"></asp:Label>
                                                </td>
                                                <td style="width: 92px" align="center">
                                                    <asp:Label ID="labStrong" runat="server" Text="强" Width="18px" Font-Size="12px"
                                                        ForeColor="#F2EFE7"></asp:Label>
                                                </td>
                                                <td style="width: 106px">
                                                </td>
                                            </tr>
                                        </table>
                                        </span>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="right" class="style1" colspan="3">
                                        确认密码:
                                        <label>
                                            <asp:TextBox ID="txtQpass" runat="server" TextMode="Password" Width="128px"></asp:TextBox>&nbsp;</label>
                                        <span class="STYLE1">*<asp:CompareValidator ID="covPass" runat="server" ControlToCompare="txtPass"
                                            ControlToValidate="txtQpass" ErrorMessage="两次密码不一致" Font-Size="12px"></asp:CompareValidator></span>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        昵 称:
                                    </td>
                                    <td>
                                        <label>
                                            <asp:TextBox ID="txtNickname" runat="server" onFocus="tNickName();" Width="128px"></asp:TextBox>&nbsp;</label>
                                    </td>
                                    <td align="left">
                                        <span class="STYLE1">*</span>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        性 别:
                                    </td>
                                    <td valign="middle">
                                        <asp:RadioButtonList ID="radlistSex" runat="server" RepeatDirection="Horizontal"
                                            Width="95px" Font-Size="12px">
                                            <asp:ListItem Selected="True"> 男</asp:ListItem>
                                            <asp:ListItem>女</asp:ListItem>
                                        </asp:RadioButtonList>
                                    </td>
                                    <td>
                                        &nbsp;
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        电 话:
                                    </td>
                                    <td>
                                        <label>
                                            <asp:TextBox onFocus="tPhone();" ID="txtPhone" runat="server" Width="127px"></asp:TextBox>&nbsp;</label>
                                    </td>
                                    <td>
                                        &nbsp;
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        E - mail :
                                    </td>
                                    <td>
                                        <label>
                                            <asp:TextBox ID="txtEmail" onFocus="tEmail();" runat="server" Width="128px"></asp:TextBox>&nbsp;</label>
                                    </td>
                                    <td align="left">
                                        <span class="STYLE1">*<asp:RegularExpressionValidator ID="revEmail" runat="server"
                                            ControlToValidate="txtEmail" ErrorMessage="邮件格式不正确" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
                                            Font-Size="12px"></asp:RegularExpressionValidator></span>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" align="right">
                                        所在城市:
                                    </td>
                                    <td>
                                        <label>
                                            <asp:TextBox ID="txtCity" onFocus="tCity();" runat="server" Width="128px"></asp:TextBox>&nbsp;</label>
                                    </td>
                                    <td>
                                        &nbsp;
                                    </td>
                                </tr>
                                <tr>
                                    <td height="40" colspan="2" align="right" valign="bottom">
                                        <label>
                                            <asp:Button ID="btnRegister" runat="server" OnClick="btnRegister_Click" Text="注 册" />
                                            &nbsp;<asp:Button ID="btnReturn" runat="server" Text="返 回" CausesValidation="False"
                                                PostBackUrl="~/Default.aspx" />&nbsp;</label>
                                    </td>
                                    <td>
                                        &nbsp;
                                    </td>
                                </tr>
                            </table>
后台部分代码如下:
 protected void btnRegister_Click(object sender, EventArgs e)
    {
        if (isNameFormar())
        {
            if (isName())
            {
                labIsName.Text = "用户名已存在!";
                labIsName.ForeColor = System.Drawing.Color.Red;
                RegisterStartupScript("", "<script>alert('请正确填写信息!')</script>");
            }
            else
            {
                string userName = txtName.Text;
                string userPass = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPass.Text, "MD5");
                string nickname = txtNickname.Text;
                string sex = "";
                if (radlistSex.SelectedValue.Trim() == "男")
                {
                    sex = "男";
                }
                else
                {
                    sex = "女";
                }
                string phone = txtPhone.Text;
                string email = txtEmail.Text;
                string city = txtCity.Text;
                string university = txtUniversity.Text ;
                string sqlIns = "insert into tb_userInfo values('" + userName + "','" + userPass + "','" + nickname + "','" + sex + "','" + phone + "','" + email + "','" + city + "','" + university +"')";
                SqlConnection con = new SqlConnection("server=.;database=db_xiGeYue;uid=sa;pwd=;");
                con.Open();
                SqlCommand com = new SqlCommand(sqlIns, con);
                if (com.ExecuteNonQuery() > 0)
                {
                    RegisterStartupScript("", "<script>alert('注册成功!')</script>");
                    txtName.Text =txtPass.Text = txtNickname.Text = txtPhone.Text = txtEmail.Text = txtCity.Text = txtUniversity.Text ="";
                    labIsName.Text = "";
                }
                else
                {
                    RegisterStartupScript("", "<script>alert('请正确填写信息!')</script>");
                }
            }
        }
        else
        {
            RegisterStartupScript("", "<script>alert('请正确填写信息!')</script>");
        }
    }
我个人感觉,有可能是使用RadioButtonList控件作为性别选择时出现问题(比如链接数据库时有问题等),就是不知道怎么改,或时其它问题,请各位老师及朋友帮帮忙,看看是怎么回事!谢谢O(∩_∩)O谢谢!
哎~~~如果说初学困难的话,那么再在初学前面加上自学,那就是难上加难再加难!
搜索更多相关主题的帖子: 注册页面 详细信息 
2011-11-02 17:57
surpassyouuo
Rank: 1
等 级:新手上路
帖 子:10
专家分:0
注 册:2011-10-26
收藏
得分:0 
对了,还有我使用SQL 2005设计的一个数据库表有列名如下:
id
userName
userPass
nickname
sex
phone
emaile
city
univercity
谢谢!
2011-11-02 18:23
surpassyouuo
Rank: 1
等 级:新手上路
帖 子:10
专家分:0
注 册:2011-10-26
收藏
得分:0 
回复 3楼 winners
呵呵,非常感谢!是我在设计数据表的时候受资料的影响,多加了一列id,才出现这个问题的!
可惜,以后再发求助就没有积分了!呵呵
2011-11-03 19:15
快速回复:【求助】vs20008调试时出现“插入错误: 列名或所提供值的数目与表定义 ...
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.032697 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved