i've gridview and sqldatasource bind,i got 2 field in gridview start date and end date,actual problem : both dates coming in format -11/4/2010 12:00:00AMi want 11-04-2010
View 4 Replies
I'm looking for the best way (Performance) to do gridview columns formating RunTime /Dynamic depending on the datatable Columns type ,I want to bind the datatable to a gridview and format the Date columns to short date, and currency columns formatted with comma ex 10,000.00 inplace 100000.00 at datatable the column type is double run time (without converting them to String) since I do a filtering and sorting at these columns.
View 3 RepliesI have written a small web app to take fill a dataset from an xml file, which is then bound to a Gridview control. The problem I am having is that I am trying to format a date field as it is currently displayed as '2010-06-03T16:37:26.043+01:00'. I can usually set a format to an item within a templatefield by setting the bind or eval text, but in this case I cannot.
XML File
[Code]....
ViewTable.aspx.vb
[Code]....
I have tried formatting the column within the rowdatabound event but with no joy. Code shown below
e.Row.Cells(10).Text = Convert.ToDateTime(e.Row.Cells(10).Text.ToString())
I need to create a gridview to show in each row, some columns from the SQL Database, and in other columns I want to have text fields, buttons and DropDownLists!
This GridView is to display the users of the web application.
First columns are name, email, and other stuff that can be easly queried to the SQL database.
Then, I need to have a column with one text field, and some buttons, in the text field the AdminUser should be able to insert some text and then click in a button to change the email/pass from the user represented in that line.
The other field I need, is a DropDownList that shows by default the Role of the user of the row, but we can choose another role and apply it, with a button in the same cell!
If I create a code-Behind query and populate the GridView, I don't know how to insert textbox's, button's, DropDownList's
If I create the GridView with the wizard, I can had TemplateFields, but I don't know how to associate the query with the BoundFiels where should be the name/email of the users.
Other problem, is that, even If I get to construct my GridView with sucess, How can I reference the row? So I can apply the changes?
200011
200009
I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:
Databound
Databound
Till Period
From Period
Databound
(I have just started programming in C#.net via Microsoft Visual Studio 2010, so I really don't have programming knowledge yet).
From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:
Databound
Databound
Till Period
From Period
Databound
200008
200005
200011
200009
I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:
Databound
Databound
Till Period
From Period
Databound
08/2000
05/2000
11/2000
09/2000
How can I do it easily? (I have just started programming in C#.net via Microsoft Visual Studio 2010, so I really don't have programming knowledge yet).
I am having a table with some fields in which one field is emp's DOB of varchar datatype.I want to display the date in Gridview in 'DD-MM-YYYY' format as well as the dates should be in sorted in descending order.
For e.g:12/03/2010' should be displayed before '12/03/2009'.
I'm hitting a wall trying to format a boundfield of a gridview. I've tried suggestion about setting the htmlencode to false, but that didn't make a difference.The column I am trying to format is:<asp:BoundField DataField="FromDate" HeaderText="Start Date" DataFormatString="{0:MM/dd/yyyy}" HtmlEncode="False" />
View 1 RepliesI 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 want to pass date from one page to another page using querystring. I have used a gridview hyperlinkfield.
When user click hyperlink in gridview the data should display on other page.
I have tried this but due to date format (dd/MM/yyyy) that is showing in gridview the hyperlink is not showing. I think '/' is creating problem. In gridview I already tried by replacing / to -.
I want to have a date format in gridview column when user is in edit mode.
That is when user is editing the date he should automatically get the format like this
'--/--/----' (i.e 12/01/2010) now he can write his desired date, he is not going to type the forward slash "/" using Key Board.
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
My web is in asp.net+vb code and sql 2005 database. In a gridview i used to convert dateformat as dd/mm/yyyy (11 Jun 2011) format
convert (varchar, DTDOB,6) as [DTDOB]
when i use only DTDOB then date format is 6/11/2011 12:00:00 AM .(i can sort my grid on DTDOB and the date is correctly sorted)
when i use convert (varchar, DTDOB,6) as [DTDOB] then date format is 11 Jun 2011. (When i sort the date is sorted as per the day only.
eg 01 Nov 93,04 Nov 93,06 Nov 92,08 Jun 91,11 Dec 93 etc.
i have a gridview , i dont know how to set the dateformat for gridview template field.
View 1 RepliesI have one problem im exporting my data into excel in that i have one column,after exporting that data to excel now it is taking system date format instead of that i want date format like mm/dd/yyyy
below in my code...
string strBaselineassessmentVisitdate = list[i].BaselineDateOfAssessment.ToString("MM/dd/yyyy");
First I am taking the data from database then im converting that to MM/dd/yyyy forma but still it taking the system date format which I don't want....
According below thread I had problem with showing date to persian and solved it
Error-Occure-when-want-to-show-date/?s=2#Replies
Now this problem happen for below code I used datalist to showing date
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width = "100px" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<%# System.Convert.ToDateTime(miladitoshamsi(Eval("Date"))).ToString(" yyyy/MM/dd") %>
[Code] ....
ERROR : Server Error in '/behtop website' Application.
Year, Month, and Day parameters describe an un-representable DateTime.
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.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
Source Error:
Line 231: DateTime miladi = Convert.ToDateTime(miladi1);
Line 232: System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Line 233: DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi)); Line 234: //DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi), shamsi);
Line 235:
How I can change this code?
i facing a problem to change the date format at gridview display.
below is my coding:
[code]....
Looking for an example that demonstrates usage of different validations with respect to gridview.
View 1 RepliesHere is the URL to the Screen shot [URL] I want to display the data in the format that is represented in the screenshot. All the data that is shown is retrieved from Sql Server-2005 Database. Which is the best option for such kind of data representation? I have read in the forums, from them I could not get a clear perspective. Some were suggesting listview others nested datagrid, some repeater control. which one would be a easier, proper and accurate way to go forward ?? Along with some reasons (if possible !!). And I'm using visual studio 2008, .net Framework 3.5, asp.net with c# and I'm NOT using LINQ in my project and it is a web application. URL Screen Shot: [URL]
View 2 RepliesI have two databases. When I am using MS Visual Web Developer, I can drag the table onto the webpage and it gives me check boxes to Insert, Update, Delete,...When I do the exact thing using the other database, it only has check boxes forpaging, sorting and selection. What is the difference? I seem to have all teh same permissions in both databases.
View 2 Replieshow to convert date in textbox which is in format(dd/mm/yy) to mmddyy before submit to database.
View 21 RepliesI want to display the data in the format that is represented in the screenshot. All the data that is shown is retrieved from Sql Server-2005 Database. Which is the best option for such kind of data representation? I have read in the forums, from them I could not get a clear perspective. Some were suggesting listview others nested datagrid, some repeater control. which one would be a proper and accurate way to go forward ?? Along with some reasons (if possible). And I'm using visual studio 2008, .net Framework 3.5, asp.net with c# and I'm NOT using LINQ in my project and it is a web application. The same picture can also be found at [URL]
View 4 RepliesI am using a dataview to read a certain record from a database and then adding these values to different elements on a form (label, textbox) ..
One of the fields is a date/time and i only want to display the date without the time..
code:
{on page load}
Dim dv As System.Data.DataView = CType(DEDS.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
lbl_startdate.Text = dv.Table.Rows(0).Item("'<%# Eval("evt_startdate","{0:d}")%>'").ToString()
' DEDS is my SqlDatasource ..
'evt_startdate is the date field coming from the DEDS datasource
.. It's not working .. I'm not sure how i should alter the date format ..
I have to display a news component peice in our website's homepage. The news information (date and news) is retreived from the db and I have queried to retreive that info now. My question is really simple --> How do I display the news with the timestamp in this specific format:
Database has it in this format:
2010-06-21 00:00:00. ----News blah blah A
2010-06-18 00:00:00. -----News blah blah B
2010-05-21 00:00:00. -----News blah blah C
2009-04-15 00:00:00. -----News blah blah D
I need the above information to be displayed in the following format:
2010
June
06/21/2010 - News blah blah A
06/18/2010 - News blah blah B
May
05/21/2010 - News blah blah C
2009
April
04/15/2010 - News blah blah D
I am using labels like this and few date formats which would extract like this, but some coding to retreive the earliest news first depending on the yr / month and date would be great.
asp:Label
ID="Label1"
runat="server"
Text='<%#
Eval("EffectiveDate", "{0:yyyy}")%>'
Font-Names="timesNewRoman"
Font-Size="10pt"
ForeColor="black"
Font-Bold="true"></asp:Label></td>
I am trying to assign datetime to the textbox when a date selected from asp.net Calendar control in the following format:
06/05/2010 12:25:04 PM
but I have tried following four options that are not giving required date format. What to do?
Calendar1.SelectedDate.ToShortTimeString() = 12:00:00 AM
Calendar1.SelectedDate.ToShortDateString() = 03/05/2010
Calendar1.SelectedDate.ToLongDateString() = 03/05/2010
Calendar1.SelectedDate.ToLongTimeString() = 12:00:00 AM
I want to display 06/05/2010 12:25:04 PM
