最近学习ASP.NET,写了一个数据插入的代码,但一运行就报错。代码如下:string KindNameStr = TxtKindName.Text.Trim();//获取文本框的值
SqlConnection conn = new SqlConnection();//创建数据库连接对象
conn.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=zhongyuan;User ID=sa;Password=012345";//设置数据库连接字符串
conn.Open();//打开数据库连接
SqlCommand comm = new SqlCommand("insert into BigKind (cKindName) values ('"+KindNameStr+"')",conn);
comm.ExecuteNonQuery();
labAddState.Text = "类别添加成功!";
报错信息如下:不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。源错误:
行 27: conn.Open();//打开数据库连接
行 28: SqlCommand comm = new SqlCommand("insert into BigKind (cKindName) values ('"+KindNameStr+"')",conn);
行 29: comm.ExecuteNonQuery(); 行 30: labAddState.Text = "类别添加成功!";
行 31: }
源文件: d:\test\KindManage\BigKindAdd.aspx.cs 行: 29 堆栈跟踪:
[SqlException (0x80131904): 不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
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
KindManage_BigKindAdd.Button1_Click(Object sender, EventArgs e) in d:\test\KindManage\BigKindAdd.aspx.cs:29
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
SqlConnection conn = new SqlConnection();//创建数据库连接对象
conn.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=zhongyuan;User ID=sa;Password=012345";//设置数据库连接字符串
conn.Open();//打开数据库连接
SqlCommand comm = new SqlCommand("insert into BigKind (cKindName) values ('"+KindNameStr+"')",conn);
comm.ExecuteNonQuery();
labAddState.Text = "类别添加成功!";
报错信息如下:不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。源错误:
行 27: conn.Open();//打开数据库连接
行 28: SqlCommand comm = new SqlCommand("insert into BigKind (cKindName) values ('"+KindNameStr+"')",conn);
行 29: comm.ExecuteNonQuery(); 行 30: labAddState.Text = "类别添加成功!";
行 31: }
源文件: d:\test\KindManage\BigKindAdd.aspx.cs 行: 29 堆栈跟踪:
[SqlException (0x80131904): 不能将值 NULL 插入列 'nID',表 'zhongyuan.dbo.BigKind';列不允许有空值。INSERT 失败。
语句已终止。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
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
KindManage_BigKindAdd.Button1_Click(Object sender, EventArgs e) in d:\test\KindManage\BigKindAdd.aspx.cs:29
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货