该字符串未被识别为有效的布尔值。
说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.FormatException: 该字符串未被识别为有效的布尔值。源错误:
行 49:
行 50: PrepareCommand(conn, cmd, null, nType, nText, paras);
行 51: int rows = cmd.ExecuteNonQuery();
行 52: cmd.Parameters.Clear();
行 53: return rows;
源文件: e:\网站及项目\lijun\App_Code\SqlHelper.cs 行: 51 堆栈跟踪:
[FormatException: 该字符串未被识别为有效的布尔值。]
System.Boolean.Parse(String value) +9624494
System.String.System.IConvertible.ToBoolean(IFormatProvider provider) +15
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +9508988
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +5075522[FormatException: 将参数值从 String 转换到 Boolean 失败。]
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +5074733
System.Data.SqlClient.SqlParameter.GetCoercedValue() +32
System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) +103
System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters) +209
System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc) +237
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
SqlHelper.ExcuteNonQurey(String nText, CommandType nType, SqlParameter[] paras) in e:\网站及项目\lijun\App_Code\SqlHelper.cs:51
Manager_EditerMessage.ButtonUpdate_Click(Object sender, EventArgs e) in e:\网站及项目\lijun\Manager\EditerMessage.aspx.cs:101
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
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 incl
说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.FormatException: 该字符串未被识别为有效的布尔值。源错误:
行 49:
行 50: PrepareCommand(conn, cmd, null, nType, nText, paras);
行 51: int rows = cmd.ExecuteNonQuery();
行 52: cmd.Parameters.Clear();
行 53: return rows;
源文件: e:\网站及项目\lijun\App_Code\SqlHelper.cs 行: 51 堆栈跟踪:
[FormatException: 该字符串未被识别为有效的布尔值。]
System.Boolean.Parse(String value) +9624494
System.String.System.IConvertible.ToBoolean(IFormatProvider provider) +15
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +9508988
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +5075522[FormatException: 将参数值从 String 转换到 Boolean 失败。]
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +5074733
System.Data.SqlClient.SqlParameter.GetCoercedValue() +32
System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) +103
System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters) +209
System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc) +237
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
SqlHelper.ExcuteNonQurey(String nText, CommandType nType, SqlParameter[] paras) in e:\网站及项目\lijun\App_Code\SqlHelper.cs:51
Manager_EditerMessage.ButtonUpdate_Click(Object sender, EventArgs e) in e:\网站及项目\lijun\Manager\EditerMessage.aspx.cs:101
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
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 incl
不是数字。string 类型好像不能转bool类型。应该是传入的参数不对。
这个里面的参数你给的不对
如果你给个字符串 ,比如“1”那就不行
但是如果你给个“True”那就可以
自己看数据库里内容对不对