Problem to exceptionRSS

• • Reply
  wmec

  Contributor

  6381 Points

  5674 Posts

  Problem to exception

  Nov 06, 2018 05:02 AM|wmec|LINK

  Hi,

  I have got

     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, BulkCopySimpleResul
  

  with these codes

              List<HouseData> houseList = new List<HouseData>();
              try
              {
                  using (SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["Mssqlconn3"].ConnectionString))
                  {
                      using (SqlCommand sqlCmd = new SqlCommand("SELECT cast(ROW_NUMBER() OVER (ORDER BY house_id ASC) as int) serial_id, house_id, rent_type, house_name, area, area_unit2, clicked_times, area_unit, area_size, isnull(construct_area_size,0) construct_area_size, isnull(request_times,0) request_times, release_period_from, CONVERT(varchar,register_date,105) register_date,CONVERT(varchar,upd_date,105) upd_date, address1, address2, price, price_curr, ltrim(rtrim(cast(raised_by_user_id as varchar))) raised_by_user_id FROM house_tab where isnull(raised_by_user_id,0)=@raiser and isnull(deleted,'')<>'Y'", sqlConn))
                      {
                          sqlConn.Open();
                          sqlCmd.CommandType = CommandType.Text;
  
                          sqlCmd.Parameters.AddWithValue("@raiser", System.Web.HttpContext.Current.Session["user_id"]);
                          SqlDataAdapter sqlAd = new SqlDataAdapter(sqlCmd);
                          DataTable sqlDt = new DataTable();
                          sqlAd.Fill(sqlDt);
                          sqlConn.Close();
                          if (null != sqlDt)
                          {
                              houseList = sqlDt
                                              .AsEnumerable()
                                              .Select(dataRow => new HouseData
                                              {
                                                  serial_id = dataRow.Field<int>("serial_id"),
                                                  house_id = dataRow.Field<int>("house_id"),
                                                  house_name = dataRow.Field<string>("house_name"),
                                                  address1 = dataRow.Field<string>("address1"),
                                                  address2 = dataRow.Field<string>("address2"),
                                                  area = dataRow.Field<string>("area"),
                                                  area_unit = dataRow.Field<string>("area_unit"),
                                                  rent_type = dataRow.Field<string>("rent_type"),
                                                  register_date = dataRow.Field<string>("register_date"),
                                                  upd_date = dataRow.Field<string>("upd_date"),
                                                  area_unit2 = dataRow.Field<string>("area_unit2"),
                                                  clicked_times = dataRow.Field<decimal>("clicked_times"),
                                                  construct_area_size = dataRow.Field<decimal>("construct_area_size"),
                                                  request_times = dataRow.Field<decimal>("request_times"),
                                                  area_size = dataRow.Field<decimal>("area_size"),
                                                  price = dataRow.Field<decimal>("price"),
                                                  price_curr = dataRow.Field<string>("price_curr"),
                                                  raised_by_user_id = dataRow.Field<string>("raised_by_user_id"),
                                              })
                                              .ToList();
                          }
                      }
                  }
              }
  

  why?

  Many Thanks & Best Regards,
  HuaMin Chen
  
• • Reply
  Jenifer Jian...

  Member

  630 Points

  228 Posts

  Re: Problem to exception

  Nov 07, 2018 09:07 AM|Jenifer Jiang|LINK

  Hi wmec,

  It seems that the error message tells you that some of the values obtained are too long to be stored in the specified column.

  I’m not sure about your database design about the sizes of your columns.

  Maybe there's a limited size there and I suggest that you could check it.

  For more about the solution of the error message, you could refer to the thread in this link: 

  https://stackoverflow.com/questions/27204284/c-sharp-connection-to-sql-database-error 

  Best Regards,

  Jenifer

  Please remember to "Mark as Answer" if suggestion helps.
• • Reply
  DA924

  Contributor

  2681 Points

  2440 Posts

  Re: Problem to exception

  Nov 07, 2018 01:25 PM|DA924|LINK

  You have posted nothing about the exception. There has to be an exception message that you are not posting that tells what the exception is about.

  If you find the post has answered your issue, then please mark post as 'answered'.
• • Reply
  PatriceSc

  All-Star

  42860 Points

  14765 Posts

  Re: Problem to exception

  Nov 07, 2018 02:19 PM|PatriceSc|LINK

  Hi,

  I believe we have gone through that previously. The problem is that you are showing Exception.StackTrace rather than Exception.ToString(). As a result when an exception happens you know just WHERE it happens while Exception.ToString() would show both WHAT happens (including inner exceptions) as well as the stack trace.

  Any chance you could know change this. It should really change your life ;-) - at least regarding debugging.