Forms Data Controls :: Input String Was Not In Correct Format
Aug 11, 2010
there is a template field in gridview this is basically for showing amount.
<asp:TemplateField HeaderText="Amount" ConvertEmptyStringToNull="False">
<ItemTemplate>
<%#GetQTY1(float.Parse(Eval("Sub_ContractAmt").ToString())).ToString("N2")%>
</ItemTemplate>
</asp:TemplateField>
if my data base field has any value then it shows no error. but if this fiels is null then it shows error
input string was not in correct format while binding the gridview.
so can you please tell me the method that if this field has null value then what should I do so that i dont get this error. this fields might be null.
View 8 Replies
Similar Messages:
Oct 7, 2010
I am trying to get the delete to work on my gridview. I've added a
DataKeyNames="ID"
but when i click delete i get Input string was not in a correct format.
View 7 Replies
Mar 5, 2011
I'm stumped on this one... it seems really simple, but I can't get around it. I am pulling 2 values (discount percent, discount amount) from a formview label control. I want to use these numbers in a calculation, but I can't seem to get the format correct.
I hit the error on this statement:
DiscountAmt = Convert.ToDouble(fvDiscountResults.FindControl(
"DiscountSubtotal1"
).ToString)
[Code]....
View 2 Replies
Oct 27, 2010
[Code]....
I've used only linkbutton and I do not know if what influence it.
View 3 Replies
Jul 8, 2010
I am getting "input string not in correct format" error and I have tried a few variations and still no dice. zSessvar1 is equal to 159 and when I substitute the actual nbr, it will work.
Dim cmd1
As OleDbCommand =
New OleDbCommand("Select nbrofcomments from table1 where PID = "
+ zsessvar1, myConn)
View 9 Replies
May 13, 2010
I have a Data field of type "Integer" below is my Edit Template for this Data field
<asp:TextBox
ID="OfficeSqFtTextBox"
runat="server"
Text='<%# Bind("OfficeSqFt", "{0:#,0}") %>'
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???
View 8 Replies
Jun 10, 2010
I followed the tutorial outlined at
http://www.codedigest.com/Articles/ASPNET/232_Picasa_Style_Photo_Album_Using_ListView_Control_in_ASPNet_35.aspx originally written in C#. I'm using VB.Net (Asp.net 4.0) and I'm getting the following errors for Albums.aspx, Photos.aspx, PhotoViewer.aspx pages. I have attached a screenshot of my two tables.Input string was not in a correct format.
Description:An unhandled exception occurred during the execution of the current web request. Please 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.
Source Error: [Code]....
Source File: A:TS_Main2010TursingAlbums.aspx Line: 26
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please 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.Source Error: [Code]....
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error,[Code]....
Source File: A:TS_Main2010TursingPhotoViewer.aspx.vb Line: 39
View 8 Replies
Apr 29, 2010
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]....
View 7 Replies
Dec 27, 2010
I'm trying to populate a detailsview according to the selected row in a gridview. How do you choose what the selectedindex is? For example my sql statement is:
SELECT [Assignment_ID], [Staff_ID], [Client_ID], [Day], [Month], [Year], [Start_Time], [Job_Type], [Billable_Time], [Travel_Time], [KM_Travelled], [NC_Time], [SP_Time], [Billed], [Description] FROM [Assignment] WHERE ([Assignment_ID] = @Assignment_ID)
and @ assignment_ID is gridview.selectedindex
but when it runs I get the 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.
Source Error:
[Code]....
Stack Trace:
[Code]....
View 3 Replies
Jun 8, 2010
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:
[Code]....
View 7 Replies
Sep 20, 2010
I am trying to update a coulmn in datatable but keep getting error:
Input string was not in a correct format.Couldn't store < > in SortOrder Column. Expected type is Int32.
SortOrder is column of Type Integer that either contain Null or number.
[Code]....
View 7 Replies
Jan 13, 2010
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:
[Code]....
View 2 Replies
May 7, 2010
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.
Source Error:
[Code]....
heres my row databound event:
[Code]....
View 8 Replies
Jan 27, 2014
Based on below code, how to convert the data ? For the UnitCost input Data is float.
protected void CalNett_TextChanged(object sender, EventArgs e) {
int GrossWeight = Convert.ToInt32(WMGrossWeight.Text.ToString());
int UnitCost = Convert.ToInt32(WMUnitCost.Text.ToString());
decimal NettWeight = (GrossWeight - 85);
decimal TotalCost = (NettWeight * UnitCost);
if (WMItem.SelectedValue == "SW.307.004 ")
this.WMTotalCost.Text = TotalCost.ToString();
}
View 1 Replies
Apr 6, 2010
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?
View 5 Replies
Jan 10, 2011
I have the textbox input the double number like 0.5 or 2.1 then click the submit insert to database, but show the error. Server Error in '/' Application. 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.
Source Error:
[Code]....
Source File: c:inetpubwwwrootInformationadd_detail_menu2.aspx.vb Line: 6 Stack Trace:
[Code]....
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
View 2 Replies
Oct 22, 2010
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?
View 9 Replies
Jun 21, 2010
I am using a SQL stored procedure to insert client records into multiple tables.
this is my datasource markup:
[Code]....
I am using a multiview to step through the input pages then on the last view there is a submit button that fires this:
[Code]....
this is my stored procedure:
[Code]....
View 5 Replies
Nov 25, 2010
This is the error:
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please 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.
Source Error:
[Code]....
View 7 Replies
Aug 5, 2010
im using iTextSharp to render pdf files.i try to append a srting to HtmltoPdf class like this
first.AppendHtml("<div style="width:501px;height:251px;padding:18px;border:1px solid #cbcccd;font-family:Verdana, Geneva, sans-serif;font-size:9px;color:#000;float:left;"><table width="501px" border="0" cellspacing="0" cellpadding="0"><tr><td width="269"
height="15">Name : Bryan Costa</td>" + [code]...
what is the wrong with this string.
View 2 Replies
Aug 16, 2010
[Code...]
Dim RetVal
As SqlParameter =
New SqlParameter()
RetVal.ParameterName = "@NewID"
RetVal.SqlDbType = SqlDbType.Int
RetVal.Size = 5
RetVal.Direction = ParameterDirection.Output command.Parameters.Add(RetVal)
connection.Open()
command.ExecuteNonQuery()
TextBox3.Text = command.Parameters("@NewID").Value Convert.ToInt32(TextBox3.Text)
View 6 Replies
Jun 27, 2010
I create a project on my local host (xp) that work o.k.
I up load the project to the test server (win Server 2008), work o.k.
But when I up load the project to the production server (win Server 2008). It gets that exception(Line 303):
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.
Source Error:
[Code]....
View 3 Replies
May 7, 2015
I got this error: Input string was not in a correct format.
Source Error:
Line 63: protected void btn_save_add_Click(object sender, EventArgs e)
Line 64: {
Line 65: pcd.Pro_Comp_ID = Convert.ToInt32(txt_prod_of_compID_add.Text);
Line 66:
Line 67: //int companyId = Convert.ToInt32(ddl_choose_companyName.SelectedValue);
I revise 'Pro_Comp_ID' in sql and .net it all of datatype 'int' where is the error?
View 1 Replies
Dec 30, 2013
In my project i Found the following error while submitting the form
"Input string was not in a correct format"
Here below my code
public partial class Add_product1 : System.Web.UI.Page {
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DEMO_DbConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
SqlDataReader rdr = null;
[Code] ....
and this is my form design
View 1 Replies
Nov 7, 2013
error...Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please 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.
Source Error:
Line 59: Primarykey = Convert.ToInt32(GridView2.DataKeys[i].Value);
Line 60: ProductName = ((Label)GridView2.Rows[i].FindControl("lblproductname")).Text;
Line 61: txtCostPrice = Convert.ToInt32(((TextBox)GridView2.Rows[i].FindControl("txtcostprice")).Text);
Line 62:
my code
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
[code]....
View 1 Replies
