The string was not recognized as a valid Boolean value. Who helped me solve it! ~~ To whom

wzq0729

Exception Details: System.FormatException: The string was not recognized as a valid boolean.

Source error:


Line 57: comm.Parameters ["@ pageCount"]. Direction = ParameterDirection.Output;
Line 58: cnn.Open ();
Line 59: comm.ExecuteNonQuery ();
Line 60: // DataTable dt;
Line 61: //dt=Comm.tools.ConvertDataReaderToDataTable(dr);
 

Source file: d:\web\12\protest.aspx.cs Line: 59

Stack trace:


[FormatException: The string was not recognized as a valid boolean. ]
   System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery () +196
   info.protest.CutPageData () in d:\web\12\protest.aspx.cs: 59
   info.protest.Page_Load (Object sender, EventArgs e) in d:\web\12protest.aspx.cs: 28
   System.Web.UI.Control.OnLoad (EventArgs e) +67
   System.Web.UI.Control.LoadRecursive () +35
   System.Web.UI.Page.ProcessRequestMain () +750

wanted

Post all the code

lynntian

If the string here is "true" or "false", it may not report an exception!

sabs_nn

1\confirm that your .aspx file name is not comm.aspx
2\change comm to _comm try

wzq0729

Full code:
SqlConnection cnn = new SqlConnection (ConfigurationSettings.AppSettings ["ConnectionString"]);
SqlCommand _comm = new SqlCommand ("proc_ListPageInt", cnn);
_comm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = null;
_comm.Parameters.Add ("@ tblName", SqlDbType.NVarChar, 200);
_comm.Parameters ["@ tblName"]. Value = "info_public";
_comm.Parameters.Add ("@ fldName", SqlDbType.NVarChar, 500);
_comm.Parameters ["@ fldName"]. Value = "";
_comm.Parameters.Add ("@ pageSize", SqlDbType.Int);
_comm.Parameters ["@ pageSize"]. Value = 5;
_comm.Parameters.Add ("@ page", SqlDbType.Int);
_comm.Parameters ["@ page"]. Value = 1;
_comm.Parameters.Add ("@ fldSort", SqlDbType.NVarChar, 200);
_comm.Parameters ["@ fldSort"]. Value = "infoid";
_comm.Parameters.Add ("@ Sort", SqlDbType.Bit);
_comm.Parameters ["@ Sort"]. Value = "1";
_comm.Parameters.Add ("@ strCondition", SqlDbType.NVarChar, 1000);
_comm.Parameters ["@ strCondition"]. Value = "";
_comm.Parameters.Add ("@ ID", SqlDbType.NVarChar, 150);
_comm.Parameters ["@ ID"]. Value = "infoid";
_comm.Parameters.Add ("@ Counts", SqlDbType.Int, 0);
_comm.Parameters ["@ Counts"]. Direction = ParameterDirection.Output;
_comm.Parameters.Add ("@ pageCount", SqlDbType.Int, 0);
_comm.Parameters ["@ pageCount"]. Direction = ParameterDirection.Output;
cnn.Open ();
_comm.ExecuteNonQuery ();

wzq0729

proc_ListPageInt stored procedure:

http://www.cnblogs.com/hertcloud/archive/2005/12/21/301327.html

aaajet

learning

simonsi

_comm.Parameters.Add ("@ Sort", SqlDbType.Bit);
_comm.Parameters ["@ Sort"]. Value = "1";
==>
_comm.Parameters.Add ("@ Sort", SqlDbType.Bit);
_comm.Parameters ["@ Sort"]. Value = true;