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 .
i use the grid view so edit & Delete the records. using
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
But due to more fields the gridview is out of the Master page.
So how can I manage the gridview columns especially at time of edit the records.
I have 2 fields being displayed in a Gridview, StartTime, EndTime. I want to create a 'Time" column which shows the elapsed time in HH:MM format. (StartTime - EndTime) This was all generated with VS2008, table is pulled from an SQL Query.
View 1 Repliesi facing a problem to change the date format at gridview display.
below is my coding:
[code]....
when I adding for first time it's added successfully but for the second time it raises this error:
Input string was not in a correct format.
protected void btn_save_add_Click(object sender, EventArgs e)
Line 147: {
Line 148: pro.Pro_ID = Convert.ToInt32(txt_prodID_add.Text);
Line 149: pro.Pro_Name = txt_prod_name_add.Text;
Line 150: pro.CategoryProd_ID = Convert.ToInt32(ddl_ctegOf_Product_add.SelectedValue);
I'm populating my dropdownlist control with data that is stored in database which is in time format.Data, after being populated into dropdownlist, looks like 13:09:49.5577199.I want to convert this into something like this - 01:09 PM.To convert date format in dropdownlist, we do it with dataTextFormatString="{0:dd MMMM}". But for converting time format, how to go about?
View 2 RepliesYou'd think since MS SQl Server 2008 and asp.net are both Microsoft products, asp.net would support the new "time" datatype but anyway.
This is one data field in gridview called "timesort"
<asp:templatefield HeaderText="timesort" SortExpression="timesort">
<EditItemTemplate>
[code]...
How can i convert string time into 12 hours (AM,PM) time format? Like if input string will like "2320" than i want answer like "11:20 PM".
View 2 RepliesI have a datetime column in a database that stores the date like like this - 2011-02-27 16:00:00.000
I only want to display the time in a gridview, and need to display it in this fromat "4.00pm" . I'm using template fields to write the date and time to the gridview like this...
<asp:TemplateField HeaderText="Time">
<ItemTemplate>
<asp:Label ID="lblTime" runat="server" Text='<%# Bind("Time") %>'></asp:Label>
</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
Does anyone know how I can out just the time like this "4.00pm"?
I'm currently developing a system for booking of discussion room in a college. This system will allow the staff to help the students to make booking in advanced as well as for instant walk in usage.I've got a table to keep track of bookings, another for walk in and one for time slot.
For the time slot table, it includes start time slot and end time slot, which is 30 minutes interval for each.What i'm currently facing is that the system could not display the correct available time slot. I think it's the formula problem which I still can't get it solved.
Example:If the booking time is 8.30am - 9.00am, I have no problem showing the 1st slot as N/A.
But if the time is 8.45am - 9.15am, the system only update the 1st slot as N/A while the 2nd slot still remain as AVAILABLE which is wrong. Because since the time ends at 9.15, I would like the slot 9.00am - 9.30am to be N/A as well.
This would be my code:
[Code]....
I have total 21 time slot count in my table. And the arrCC113Availability is an ArrayList keeping track of the availability of each slot for that particular room.Is there any other formula which can cater for all the conditions?
I would like to format the date time to
Monday 7th May 2010 9:00 am
What is the format string using <%# Eval("StartSession", "{0:?????}") %>?
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);
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.
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.
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
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.
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]....
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
[Code]....
I've used only linkbutton and I do not know if what influence it.
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)
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.
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 ?
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???
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
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