Forms Data Controls :: Adding Total For Column Input String Error?
May 13, 2010
I have a gridview which has a total column to total each row, and i am trying to add a label to total the column i have got this far:
But am receiving this error:
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
i am creating a total column which multiplies the price by quantity in my gridview but am stuck on converting the input strings.
The price is stored as a decimal in my database and the quantity is a nvarchar.
i am receiving this error:
Input string was not in a correct format.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
I need to add a sum total for each column in my gridview and I need to do this programmatically because my gridview mark up does not contain any column mark because the columns themselves are added programmatically.
This there away to do this on the row data bound event? If so how do you do it? I have 10 columns which each need to have a total.
i have one grid which have 5 columns 1 for subject,2,3,4 for marks which have textbox to insert obtained marks,and last column have one lable to display total of (2+3+4),now i want total value on textbox event,when user enter any value to any column of textbox i need to display total of all three columns in total column.
Here is my problem When I try to edit this record, in the Edit mode, this Data field shows the number correctly with formatted e.g. 22,344 if I click on Save the record, it will give me the error "Input string was not in correct format". If I edit this number and remove the "," between numbers then it saves. What can I do to make this work? If I remove the "{0:#0}" then in the edit mode the number will show as 22344 without any comma separation. Note: On the same page I have other Data field of type "Money" and it works with the format applied ???? why does it works with the Money type and not Int???
I got a "Input string was not in the correct format" exception but can't see the problem. The exception had no information to show what was causing the error. It's thrown before the BLL or DAL are called so it must be in the mark up. The parameters are in the right order.[Code]....
I am trying to sum the rows in a gridview. It works find except when I do an update. Then I get the following error:Input string was not in a correct format. The error occurs when it its the Total1 +=gr1.cells(5).text or the Total2 area. Here is my code to sum the rows:
I have gridview control that has data binded by using EF. Whenever I try to sort my gridview I get this error: "Input string was not in a correct format." This error points to the following line of code: "int index = Convert.ToInt32(e.CommandArgument);"
AdministracijaVrstaAktivnosti.aspx
[Code]....
AdministracijaVrstaAktivnosti.cs
[Code]....
I'm not sure what do I have to fix if I want to sort the columns.
If I bind the data manually what is the code for codebehind to allow sorting for particular columns.
I have a gridview to update soem records, it works on my development laptop but when i use it on the webserver i get the following error:
Exception Details: System.FormatException: Input string was not in a correct format.
Source Error: [Code]....
Stack Trace: [Code]....
I have another page with a gridview that does exactly the same but from another table, and that works both on the development laptop and the webserver.the code is:
I'm retreiving information from a Progress database and databinding it to a repeater control. The line with repeater1.databind() gets an error saying "Input string was not in a correct format". The weird thing is that I only get it for one specific date, ie. when I choose rows based on a date in a specific column. That would suggest there is something wrong with the data in these rows, but I cant find anything. And you basically can not put anything "corrupted" in it, its a commercial system which I have not developed myself.
What are the possible reasons for this error? Why does it trigger on databinding and not when, for instance, I try to convert a value?
I have a gridview that was displaying and handling postbacks correctly, that is, until I upgraded to .net 4.0 (vs 2010) from .net 3.5. Now I am getting the classic (and in this context meaningless) "Input string was not in a correct format" error upon postback. The postback is initiated by a command button and the row command event handles everything nicely.
The trace shows internal grid postback handling and nothing else:
[FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +9594283 System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119 System.Convert.ToInt32(String value, IFormatProvider provider) +48 System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +1047....
From experience, I know this happens on late binding with wrong type casting on the ASPX side of things. However, nothing has changed. The code is the same, the only thing that changed is the upgrade to 4.0.
I have tried everything I (and a coleague) can think of to figure out what the issue is without luck. No error is raised on the code behind in any method. The only error raised is the Page_Error event and the error object contains the same crap you see in the yellow screen dump (above).
UPDATE: I narrowed the issue down to the RaisePostBackEvent method. I had to reflect the System.Web (for educational purposes of course :) assembly to figure out the code executing after my RowCommand logic(which is fine) breaks. This happens in the HandleEvent method. It checks for known command names (e.g. Select) and if it can't find a match, it defaults to the following:
[Code]....
Is this a bug or am I doing something wrong? The row object is NULL which is why it defaults to the cast. The cast assumes the argument to be an integer however and in my case I am passing a string as an argument?
//Read string contents using stream reader and convert html to parsed conent var parsedHtmlElements = HTMLWorker.ParseToList(new StringReader(contents), null); //Get each array values from parsed elements and add to the PDF document foreach (var htmlElement in parsedHtmlElements) pdfDoc.Add(htmlElement as IElement); //Close your PDF pdfDoc.Close(); Response.ContentType = "application/pdf"; //Set default file Name as current datetime Response.AddHeader("content-disposition",
[Code] ....
Error: Input string was not in a correct format. Contents in html file giving error ...
I am using Gridview to show open, closed and all support cases (changeable by radio button postback) and am trying to get the total sum of the TimeInMinutes column and display it in the footer. Is this possible and how can I accomplish this?
There is currently no code-behind but the source of the gridview is as follows:
I'll start off with a snapshot of the application i'm working on.
Basically, what's going on is i'm using a bunch of sqldatasources to track truck loads (shown) based off a date/ date range. As there are generally multiple loads that all have the same information, so the information is grabbed with a SELECT DISTINCT so that you're only seeing one entry per multitude of loads. From there, customers can select the load type they want to work with and it goes into more detail, such as who trucked the different loads in, where it came from, where it's going to, references, that kinda stuff.
My question is, would it be feasible to show how many loads there are in total per distinct select? For instance, the top entry actually has 14 loads that are similar to that entry. How would I go about showing it has that total of 14 loads that could be shown?
I am working on gridview, i want to add the total number of records in the gridview footer which are returned by the query, and also want to see the curretly showing records, suppose if we have 50 records i want to display them as viewing 1-10 of 50 records. i need to display like this of similar to this format
im having the hardest time finding information on this that makes any sense. i am using linq to get data from my SQL server 2005 database and bind it to a gridview. From the table i am pulling two fields...Reference(the item name) and Cost. In the gridview i have added two additional columns, Quantity and total. I need to allow the user to change the quantity field to the amount they need to order and update the total field for that row. Also i would like to show a grand total at the bottom of the gridview summing all the total fields. The totals need to be updated as soon as the the user clicks or tabs out of quantities field. Here is the code for my gridview.
I have a gridview with three columns. The last column is a cost column. I would like to add a summation record which shows a grand total of the last column like such:
