个人中心
文章发布
退出
作者热门文章
- android - 多次调用 OnPrimaryClipChangedListener
- android - 无法更新 RecyclerView 中的 TextView 字段
- android.database.CursorIndexOutOfBoundsException : Index 0 requested, 光标大小为 0
- android - 使用 AppCompat 时，我们是否需要明确指定其 UI 组件(Spinner、EditText)颜色
26
4
我正在尝试在 Visual Studio 2013 中使用 ASP.NET C# 创建一个简单的注册页面。
我在单击提交按钮以确保注册详细信息进入我尝试连接的数据库时遇到了以下错误。
Error:System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'B'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Registration.submitButton_Click(Object sender, EventArgs e) in d:\Desktop\IIPWebsite\Registration.aspx.cs:line 56 ClientConnectionId:41bb1e5f-3298-4b70-89d6-b12d0519ea55
我的aspx页面代码如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Registration.aspx.cs" Inherits="Registration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>NHH Consultants</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="http://fonts.googleapis.com/css?family=Source+Sans+Pro:200,300,400,600,700,900" rel="stylesheet" />
<link href="default.css" rel="stylesheet" type="text/css" media="all" />
<link href="fonts.css" rel="stylesheet" type="text/css" media="all" />
<!--[if IE 6]>
< link href="default_ie6.css" rel="stylesheet" type="text/css" />
<![endif]-->
<style type="text/css">
.style1
{
font-size: 1em;
}
.style3
{
font-size: 4em;
}
.style4
{
width: 208px;
}
.style2
{
width: 126px;
}
.style6
{
font-size: medium;
color: #FFFFFF;
}
.style7
{
text-align: center;
font-size: 30pt;
color: #FFFFFF;
}
.style8
{
color: #FF9933;
}
.auto-style1 {
width: 261px;
}
.auto-style2 {
width: 126px;
height: 27px;
}
.auto-style3 {
width: 208px;
height: 27px;
}
.auto-style4 {
width: 261px;
height: 27px;
}
.auto-style12 {
width: 152px;
height: 26px;
}
.auto-style14 {
width: 261px;
height: 26px;
}
.auto-style23 {
width: 152px;
height: 29px;
}
.auto-style25 {
width: 261px;
height: 29px;
}
.auto-style26 {
width: 206px;
}
.auto-style27 {
width: 206px;
height: 26px;
}
.auto-style28 {
width: 206px;
height: 29px;
}
.auto-style29 {
font-size: medium;
color: #FFFFFF;
width: 152px;
}
.auto-style30 {
width: 152px;
}
</style>
</head>
<body>
<form id="form" runat="server">
<div id="header-wrapper"
style="background-image: url('images/NYC_Night.jpg')">
<div id="header-wrapper2">
<div id="header" class="container">
<div id="logo">
<h1 style="color: #FFFFFF">NHH Consultants</h1>
</div>
<div id="menu">
<ul>
<li class="current_page_item"><a href="#" accesskey="1" title="">Homepage</a></li>
<li><a href="#" accesskey="2" title="">LOGIN</a></li>
<li><a href="#" accesskey="3" title="">About Us</a></li>
<li><a href="#" accesskey="4" title="">Contact Us</a></li>
<li><a href="#" accesskey="4" title="">Services</a></li>
<li></li>
</ul>
</div>
</div>
<div class="major">
<h2 class="style3">reliability, Anytime, anywhere</h2>
<span class="style1">Your number one electrical & mechanical engineering
consultant</span> </div>
</div>
</div>
<div id="wrapper1" class="style7">
<strong>Registration
<br />
"*" Denotes field is compulsory</strong></div>
<table class="style1">
<tr>
<td class="auto-style29">
*Username:</td>
<td class="style4">
<asp:TextBox ID="userTB" runat="server" Width="180px"> </asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="userTB" ErrorMessage="Username is required!"
ForeColor="Red" CssClass="style8"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style29">
*Password:</td>
<td class="style4">
<asp:TextBox ID="passTB" runat="server" Width="180px" TextMode="Password" ViewStateMode="Disabled"> </asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="passTB" ErrorMessage="Password is required!"
ForeColor="Red" CssClass="style8"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style29">
*Confirm Password:</td>
<td class="style4">
<asp:TextBox ID="confirmTB" runat="server" Width="180px" TextMode="Password"> </asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="confirmTB" ErrorMessage="Confirmation of password is required!"
ForeColor="Red" CssClass="style8"></asp:RequiredFieldValidator>
<br />
<asp:CompareValidator ID="CompareValidator1" runat="server"
ControlToCompare="passTB" ControlToValidate="confirmTB"
ErrorMessage="Passwords do not match!" ForeColor="Red" CssClass="style8"></asp:CompareValidator>
</td>
</tr>
<tr>
<td class="auto-style29">
*Email:</td>
<td class="style4">
<asp:TextBox ID="emailTB" runat="server" Width="180px"> </asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
ControlToValidate="emailTB" ErrorMessage="Email is required!"
ForeColor="Red" CssClass="style8"></asp:RequiredFieldValidator>
<br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
ControlToValidate="emailTB" ErrorMessage="Email is invalid!" ForeColor="Red"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
CssClass="style8"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style29">
*Company name:</td>
<td class="style4">
<asp:TextBox ID="companyTB" runat="server" Width="180px"> </asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
ControlToValidate="companyTB" ErrorMessage="Company is required!"
ForeColor="Red" CssClass="style8"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style30" style="color: #FFFFFF">
*First name:</td>
<td class="style4">
<asp:TextBox ID="firstnameTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style1" title="First name is required!">
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="firstnameTB" ErrorMessage="First name is required!" ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
</table>
<table class="style1">
<tr>
<td class="auto-style30" style="color: #FFFFFF">*Last name:</td>
<td class="auto-style26">
<asp:TextBox ID="lastnameTB" runat="server" Width="179px"></asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ErrorMessage="Last name is required!" ControlToValidate="lastnameTB" ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style12" style="color: #FFFFFF">*Address:</td>
<td class="auto-style27">
<asp:TextBox ID="addressTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style14">
<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ErrorMessage="Address is required!" ControlToValidate="addressTB" ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="auto-style30" style="color: #FFFFFF">*Postal Code:</td>
<td class="auto-style26">
<asp:TextBox ID="postalcodeTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style1">
<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ErrorMessage="Postal Code is required!" ControlToValidate="postalcodeTB" ForeColor="Red"></asp:RequiredFieldValidator>
<br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator4" runat="server" ControlToValidate="postalcodeTB" ErrorMessage="Postal code is invalid!" ForeColor="Red" ValidationExpression="\d{6}(\d{4})?$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style12" style="color: #FFFFFF">*Contact Number:</td>
<td class="auto-style27">
<asp:TextBox ID="contactnumberTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style14">
<asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" ErrorMessage="Contact number is required!" ControlToValidate="contactnumberTB" ForeColor="Red"></asp:RequiredFieldValidator>
<br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" ControlToValidate="contactnumberTB" ErrorMessage="Contact number is invalid!" ForeColor="Red" ValidationExpression="^[689]\d{7}$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style23" style="color: #FFFFFF">
<br />
Date of Birth:</td>
<td class="auto-style28" style="color: Red">
<asp:Label ID="dateLabel" runat="server" ForeColor="#FFFF66" Text="Date in YYYY-MM-DD format" Visible="True"></asp:Label>
<br />
<asp:TextBox ID="dateTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style25" style="color: Red">
<br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="dateTB" ErrorMessage="Date is invalid!" ForeColor="Red" ValidationExpression="^(19|20)\d\d[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td class="auto-style30" style="color: #FFFFFF">City:</td>
<td class="auto-style26">
<asp:TextBox ID="cityTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style1"> </td>
</tr>
<tr>
<td class="auto-style30" style="color: #FFFFFF">Fax number:</td>
<td class="auto-style26">
<asp:TextBox ID="faxTB" runat="server" Width="180px"></asp:TextBox>
</td>
<td class="auto-style1"> </td>
</tr>
<tr>
<td class="auto-style30"> </td>
<td class="auto-style26"> </td>
<td class="auto-style1"> </td>
</tr>
</table>
<table class="style1">
<tr>
<td class="auto-style2">
</td>
<td class="auto-style3">
</td>
<td class="auto-style4">
<asp:Button ID="submitButton" runat="server" onclick="submitButton_Click"
Text="Submit" Height="23px" Width="97px" />
<asp:Button ID="resetButton" runat="server" onclick="resetButton_Click" Text="Reset fields" Height="23px" Width="97px" />
</td>
</tr>
</table>
</form>
<div id="wrapper">
</div>
</form>
</body>
</html>
虽然我的aspx.cs页面代码如下:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Registration : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegisterConnectionString"].ConnectionString);
conn.Open();
string checkuser = "select count(*) from Client where cUserName= '" + userTB.Text + "'";
SqlCommand com = new SqlCommand(checkuser, conn);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("Username is already taken! Please choose another username.");
}
conn.Close();
}
}
protected void submitButton_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegisterConnectionString"].ConnectionString);
conn.Open();
string insertQuery = "insert into Client (cFirstName, cLastName, cD.O.B, cCompanyName, cAddress, cCity, cZipCode, cPhoneNo, cFax, cEmail, cUsername, cPassword) values (@firstname,@lastname,@dob,@companyname,@address,@city,@zipcode,@phoneno,@fax,@email,@username,@password)";
SqlCommand com = new SqlCommand(insertQuery, conn);
com.Parameters.AddWithValue("@firstname", firstnameTB.Text);
com.Parameters.AddWithValue("@lastname", lastnameTB.Text);
com.Parameters.AddWithValue("@dob", dateTB.Text);
com.Parameters.AddWithValue("@companyname", companyTB.Text);
com.Parameters.AddWithValue("@address", addressTB.Text);
com.Parameters.AddWithValue("@city", cityTB.Text);
com.Parameters.AddWithValue("@zipcode", postalcodeTB.Text);
com.Parameters.AddWithValue("@phoneno", contactnumberTB.Text);
com.Parameters.AddWithValue("@fax", faxTB.Text);
com.Parameters.AddWithValue("@email", emailTB.Text);
com.Parameters.AddWithValue("@username", userTB.Text);
com.Parameters.AddWithValue("@password", passTB.Text);
com.ExecuteNonQuery();
Response.Write("Congratulations! Your registration is successful!");
Response.Redirect("ClientLogin.aspx");
conn.Close();
}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}
protected void resetButton_Click(object sender, EventArgs e)
{
Response.Redirect("Registration.aspx");
}
}
最佳答案
您正在尝试将数据插入到数据库中名为 c.D.O.B. 的字段中。将它括在方括号中，事情应该可以工作，即
insert into Client (cFirstName, cLastName, [cD.O.B], ...
如果您对数据库设计有任何影响，请确保将该列名称更改为更合理的名称。列名称中的句点不适用于许多工具，并且在这里的附加值非常小。
关于c# - System.Data.SqlClient.SqlConnection 错误 : Invalid column name 'B' .，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/27752456/
26
4
0
我有一个带有帮助页面的 Web API 2 项目，该项目在本地运行良好，但当我将其推送到 Azure 时抛出此错误: Method not found: 'System.String System.S
我有两台服务器，但通常运行相同的设置 - IIS、SQL Server 等。一台给我这个错误，另一台没有。我从 Visual Studio 向两者发布相同的代码。 它们都在运行 .NET CLR Ve
System.out声明为 public static final PrintStream out。 但是你可以调用System.setOut()重新分配它。 嗯？如果它是 final，这怎么可能？
System.out被声明为 public static final PrintStream out。 但是您可以调用System.setOut()重新分配它。 嗯？如果是 final，这怎么可能？
我有这个 linq 查询: private void GetReceivedInvoiceTasks(User user, List tasks) { var areaIds = user.A
我有一个 MonoTouch 应用程序，当我为设备编译它时，出现以下错误: Error MT2002: Can not resolve reference: System.Boolean System
您好，我有一个名为 DailyVisitReport 的 View 。在该 View 中，我有两个名为 FromDate 和 toDate 的字段。如果我选择 FromDate 和 ToDate 取决
是否可以从 ObjectContext 对象中读取元组列表？ 我在存储过程中有类似这样的数据库查询 SELECT T.Id as Item1, -- this is guid T.Wo
我正在尝试创建 Odata 端点，但每当我尝试执行任何涉及日期的查询时都会收到此错误。 我在下面的非常简单示例中重新创建了它。 数据库表 EDMX(片段)
我正在尝试创建 Odata 端点，但每当我尝试执行任何涉及日期的查询时都会收到此错误。 我在下面的非常简单示例中重新创建了它。 数据库表 EDMX(片段)
我有一个方法可以从数据读取器的数据中生成类类型列表。 if (datareader != null && datareader .HasRows) { Dictionary pDict= GetP
我有一些旧的 C++ 代码，它们使用 stdio 进行输入和输出。该代码还通过 fork 生成新进程。它将 stdio 重新映射到每个新进程，以便每个 session 获取其各自的数据。 我正在考虑使
我的应用程序可以很好地构建/链接/部署到模拟器，但我只是第一次尝试将应用程序构建/部署到真实设备，并且链接器失败。 我不使用 System.Console或 ConsoleColor在我的应用程序的任
主要是我很好奇。 我们有一个名为 Unit 的对象在我们的代码库中 - 代表桥梁或道路的组件。在我们的例子中，看到带有 Unit 的 ReactiveUI 命令可能会模棱两可。作为声明中的泛型之一。
我试图将Object变量转换为StreamWriter。但是，它不起作用。有什么错？ StreamWriter file = (StreamWriter) myObject; 最佳答案 myObjec
为什么以下不编译？ using System; using System.Linq; using System.Linq.Expressions; public static class Extens
我正在使用 Visual Studio Community 2015 开发面向 .NET 4.5 的 Visual Basic 应用程序.我没有编写应用程序，所以我使用 NuGet 添加了所有缺失的依
我刚刚开始使用 powershell，我正在制作一个非常简单的加密功能。我想获取字符串中的每个字符，将其转换为 int 并添加一个选定的数字，然后将其转换回一个字符。 这工作正常: function
一些使用我的应用程序的人似乎变得越来越 System.MissingMethodException: Method not found: 'System.Object System.Windows.T
我是 C# 和实体的新手 我想知道是否有人在这里帮助我。我选择了哪个返回我的 customerid，所以我想将它作为参数传递给我的构造函数，我的构造函数参数类型是 guid 但我的选择类型不同，我不知
我是一名优秀的程序员,十分优秀！