Forms Data Controls :: Format A String Inside A GridView?
Dec 19, 2010
I have a gridview, one of the columns is a template containing a label.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ProductID" DataSourceID="SqlBestSellers" HeaderStyle-BackColor="#DDDDDD" RowStyle-HorizontalAlign="Left" RowStyle-Font-Size="10pt">
<Columns>
[Code]....
I am trying to format the cost as 10.00 but does not seem to have any effect at all. I get the values OK, but if the value of the string is 10.90, the output I get is 10.9
View 6 Replies
Similar Messages:
Feb 24, 2011
i facing a problem to change the date format at gridview display.
below is my coding:
[code]....
View 2 Replies
Oct 23, 2010
I have a gridview that is built using a objectdatasource and set to autogenerate the columns based on that source, on some other pages i have a gridview that is built within the page with template fields and so on..
in that gridview i have a field that displays the time value like so
<asp:Label
ID="lblstartDate"
runat="server"
Text='<%# DataBinder.Eval(Container.DataItem,"startDate", "{0:t}") %>'
/>
How can i apply the same formatting to my time column that is being displayed on the page that uses the autogenerated columns?
I tried to handle in SQL, but only returned the value like this : 03:11:00 and i would like to see it like this : 3:11 AM
View 3 Replies
Jul 20, 2010
I can't seem to change the format from 77.77980986554 to 77.80% in one of the footer columns.
I tried
GVreporteventas.FooterRow.Cells[3].Text = String.Format("{0:D2}%",((tva / tvo) * 100).ToString());
Did not work, the point is that no matter what format I give it, it always returned like 77.77980986554
No matter if I try currency format or other formats, so obviously is not even formatting the string or something.
View 1 Replies
Oct 5, 2010
I have a bound column.
<asp:BoundField DataField="WorkPreference" HeaderText="WorkPreference"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left" />
</asp:BoundField>
dr["WorkPreference"] = sa.WorkPreference ( This is how I bind the data to a DataRow)
The example of the data which gets bound to this column is like the following:
Communications and Marketing Officers; Environmental Assessors; Geologists and Geosciences; Geospatial/Spatial Information Officers;
What I want is that the data should be presented to the user like the following:
Communications and Marketing Officers
Environmental Assessors
Geologists and Geosciences
Geospatial/Spatial Information Officers
In short: I basicaly want to put a break where there is a colon and then bind the data to the gridview. It looks like simple but if you can let me know.
View 1 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
Dec 7, 2010
I have a gridview in which i have itemtemplates and label controls having data from sql server.
I have two fields say quantity and units and in third field i want their product. I m trying in rowdatabound event like this-
[Code]....
Here my third field is netvalue.
It is throwing error-
Input string in wrong format.
How can i achieve this?
View 5 Replies
Oct 5, 2010
I have a gridview with this form
ID_student -------exam_mark1 ------exam_mark2-----average
to calculate the average score I used this code
[Code]....
but it returns me the following error: The format of the input string is incorrect.
View 3 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
May 7, 2015
I have a SQL2012 database in the database in have a table with many cloumns one of the columns is date. on the gridview i am using a ItemTemplate field to display date
<asp:TemplateField HeaderText="DATE">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Date").ToString() =="2000/01/01 12:00:00 AM "? "" : Eval("Date" ,"{0:dd/MM/yyyy}").ToString() %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
The Problem i having is that i am testing weather the date matches something and based on that it display "" else it should display the date based on the formotting but both are not working.
View 1 Replies
Sep 1, 2010
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="LabelSubUpdateID" runat="server" Text='<%# Eval("UpdateID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Get the Label value inside the Gridview ItemTemplate and convert to string C#?
View 8 Replies
Jan 21, 2011
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.
View 3 Replies
Jan 22, 2010
I'm getting "the input string was not in the specified format" on the last line of code below. The grid is based on a SqlDataSource that has a stored procedure pulling an integer for column 0.
int theUserID = 0;
string theUserFullName =
"";
theUserID = Int32.Parse(gvUserPermissions.Rows[gvUserPermissions.SelectedIndex].Cells[0].Text);
View 2 Replies
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
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
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
Jan 15, 2011
i have problem with manging format of string at run time
actually i have infomation in tabular form , a i am accessing that in coding in string fromat and send it by mail but when i send it shows html coding and not view in tabular .
View 4 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
Aug 5, 2010
I have a ListView control that pulls a phone number from a db table. I'd like to format the phone number in the presentation layer to look like (###) ###-####.
The code line currently looks like this. The page displays the phone# but unformatted, i.e. 9999999999.
[Code]....
Based on other posts I've looked at in this forum, I've also tried:
<li>Phone: <%# String.Format("{0:(###) ###-####}", Databinder.Eval (Container.DataItem("Phone"))) %> with no success. In fact, this particular line throws an exception in my application (Input string not in the correct format).
The datatype I'm using in SQL is varchar(15)
The MSDN documentation for the String.Format method hasn't been very helpful thus far.
View 20 Replies
Feb 18, 2011
I have created a class file which gets me the state codes,license numbers and the expiration dates for the same.
I fetch the expiration dates in string format.
Each customer can have many licenses.
I have changed the format of the date (initially appearing as YYYY/MM/DD 00:00:00 when retrieved from database) to MM/DD/YYYY.
After retrieving all the licenses pertaining to a single customer, I bind them to a datalist.
Now the requirement is that for each customer, I need to sort the licenses according to the latest expiration date and then display the same.
How can this be achieved ?
View 2 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
