Web Forms :: Converting Date To Persian Date?

Jul 22, 2013

I used below code to showing date in persian format

DateTime miladi = DateTime.Now;
System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Lbldate.Text = string.Format("{0}/{1}/{2}", shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));

AND

public string miladitoshamsi(object miladi1)
{
DateTime miladi = Convert.ToDateTime(miladi1);
System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
return string.Format("{0}/{1}/{2}", shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));
}

and I have lable that I want bind it from database to show date so I wrote below code

lbldateM.Text = System.Convert.ToDateTime(miladitoshamsi(_dr1["date"])).ToString(" yyyy/MM/dd");

but below error happen

String was not recognized as a valid 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.FormatException: String was not recognized as a valid DateTime.Source Error: 

Line 52: while (_dr1.Read())
Line 53: {
Line 54: lbldateM.Text = System.Convert.ToDateTime(miladitoshamsi(_dr1["date"])).ToString(" yyyy/MM/dd"); Line 55: lblname.Text = _dr1["Name"].ToString();
Line 56: lblmob.Text = _dr1["Mobile"].ToString();

what should i do?

View 1 Replies


Similar Messages:

Databases :: Converting Varchar Date To Date Format?

Aug 14, 2010

I am using mysql and stored date in varchar format, and compare that with current date,i have stored like(dd-mm-yyyy) in database

i need to compare it with date in select query. How to take date from database in dd-mm-yyyy format.

View 1 Replies

Web Forms :: Converting Date And Time Format In Vb.net?

Apr 22, 2010

I have searched a few pages on this (including MSDN) but have not quite reached a solution. I need to convert "16/04/2010 22:39:06" to "2010-04-16 22:39:06.034" (for example).

I have already written an SQL function to do this, but would rather do this in VB.NET if possible. The date value is coming from the Date Created information of a newly uploaded file:

[Code]....

View 3 Replies

AJAX :: Date Time Picker Date Validation For Start And End Date?

Jul 10, 2010

i used below code for date time picker validation but it's not working.

Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.

I m using c# .net 2008.

[code]....

View 2 Replies

Web Forms :: Conversion Failed When Converting Date And Or Time From Character String

Nov 20, 2012

i want to search record with dropdown list and text box 

i have fields in dropdown like 

1.Orthopedics

2.Clinic

3.Pharmacy

4.ENT

when i select one field and type date in text box i want a list of record submitted on this date with the specific field 

I Tried This 

protected void Button1_Click(object sender, EventArgs e)
{
DateTime date1 = Convert.ToDateTime(TextBox1.Text);
con.Open();

[Code]....

conversion failed when converting date and/or time from character string

View 1 Replies

Converting Date To Day Of Week?

Mar 21, 2010

is there any ready to go solution within the microsoft framework, regarding conversion of date to day?

For example, i would like to convert this string 21/03/2010 (dd/mm/yyyy) to Sunday

View 4 Replies

Converting Date Time Value To Timestamp

Mar 25, 2011

I have a web page that has a textbox for users to enter a datestring to check against a database. The database that I am running my query against has datetime values set at minutes since 12/31/1899 and that returns a timestamp. What I'd like to do in my code is to convert my textbox entry into minutes since 12/31/1899. Does anyone have an easy way to do that?

View 1 Replies

Converting Date In Sql Server 2005?

Feb 7, 2010

In my application (asp.net) I am uploading the video and storing the video in databaselike videoname,videotitle,dateofuploded these are the fields. My problem is when I am displaying that video I want to display the date like '2 days ago' or ' one month ago' or 'one year ago'

How can I write the function for converting the date into that process.

Take example of youtube. On that site below the video display the date when it was uploaded.

View 2 Replies

SQL Server :: Converting From String To Date

Jan 14, 2011

I have a query that converts my string value I have stored in the database (nchar(8)). I have a stored procedure that gets the value and converts to date and when I run the select part of my stored proc to test it it successfully returns the mm/dd/yy format that I want: ex: 02/28/2010 However when I call this stored proc from my program I am getting an exception:

<Exception> Conversion failed when converting datetime from character string.

</Exception> Puzzled why the query works fine but .net gives me an exception? does anyone know how to solve this?

The part of my query that does this conversion is:

[Code]....

View 10 Replies

Asp.net - Converting Integer Into Regular Date?

Mar 7, 2011

I am being passed a date in this format DepartDate=40683, in vb.net however i cant figure out how to convert the integer into a regular date.

View 2 Replies

Converting Date String To DateTime Format Vb.net?

Dec 1, 2010

I have this example and it gives me exception "Conversion from string x to dateTime is invalid"

here is my method to validate Datetime.

Example Date string : "27/03/1985"

Public Function validateDateColumn(ByRef FieldName As String) As Boolean

Try
If IsDate(FieldName) Then
Dim actualDate As DateTime = CDate(FieldName)
Dim DtLicExp As DateTime = CDate(actualDate.ToString("d", Thread.CurrentThread.CurrentCulture))
FieldName = DtLicExp.ToString("MM/dd/yyyy")
Return True
End If
Catch ex As Exception
'FieldName &= "Format must be MM/dd/yyyy"
Return False
End Try
End Function

validate this date string formate to datetime.

I want to convert this date "27/03/1985" to datetime.

View 3 Replies

ADO.NET :: Converting Date To String And Formatting It Linq To SQL?

Aug 2, 2010

I have problem in converting date to string I am using cstr(p.tripstart) , which is returning Date as 12 Aug 2010 12:AM I need to make formating This is my code :

[Code]....

View 9 Replies

VS 2008 - Converting Character Field To Date / Time

May 3, 2010

I am reading a dataset/datatable where I have a a varchar field (25) that represents date and time in following format (this is orginally a db timestamp format): 2010-05-03 08:48:00.000 Prior to binding the datatable to a gridview I need to show date time as: 5/3/2010 8:48:00. How can I easily convert to the needed format?

View 4 Replies

Localization :: Converting Date In European And US Format In Globalization

Oct 7, 2010

I am working on globalization project.In some scenario I want to convert date in european format and sometimes in US format.I have developed method as follow.

public static string
ToCultureDate(object
oValue,string culture)
[code]...

View 2 Replies

Converting Date To String - Use Field To Group Item

Feb 11, 2010

I have createdate field in a table and I want to use that field to group items in a gridview based on the date. For instance, if the datediff is less than 25 hours ago then I want to show the word "Today" or if greater than 24 but less than 48 hours show the word "Yesterday" etc.

View 6 Replies

SQL Server :: Arithmetic Overflow When Converting String To Date

Mar 24, 2011

using sql server 2005. I am working with an existing database field and there is a field where the string in this format: YYYYMMDD, for example 05/16/2002 is displayed as:

<example>
20020516
</example>

anyways I am trying to convert that string to a date like so:

[Code]....

however when I try to do this I am getting the following error
<ERROR>

Arithmetic overflow error converting expression to data type datetime.
</ERROR>

does anyone know a good solution for this? I just want to convert the string to datetime so I can use the value in my WHERE clause.

View 6 Replies

Converting A DetailsView TemplateField Cell Value To Short Date String

Sep 7, 2010

I have a detailsView whose date values in a cell are currently being displayed in longDateFormat, i want to convert all date values in this DetailsView to short date.

For example, instead of 6/1/2010 12:00:00 AM, i want to display just 6/1/2010

For a Gridview, i can achieve that by the code blow

Protected Sub DetailsView4_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailsView4.DataBound
If e.Row.RowType = DataControlRowType.DataRow Then
For i As Integer = 0 To e.Row.Cells.Count - 1
Dim cellDate As Date
If Date.TryParse(e.Row.Cells(i).Text, cellDate) Then
e.Row.Cells(i).Text = String.Format("{0:d}", cellDate)
End If
Next
End If
End Sub

How can achieve the same with a DetailsView?

View 1 Replies

Web Forms :: To Select A Value From One Of The Other Dropdownlist Controls It Puts The Date Back To Today's Date

Mar 14, 2011

I have a window that has 3 dropdownlist controls and a textbox with a Calendar Extender associated to it.

I have the following on my pageload event so when the Page loads the current Date is put in the date textbox:

[Code]....

I can change the date fine but when I select a value from one of the other dropdownlist controls it puts the date back to today's date...The only place I am setting the Date to the current date is in the pageload event...

how can I get it to keep the date to what I change it to after I select a new value from one of the dropdown lists?

View 4 Replies

Web Forms :: Compare Validator To Valid Date Greater Then Start Date?

Feb 21, 2011

i already defined culture too in page. but still it's showing enter valid date

my markup

[Code]....

View 5 Replies

Forms Data Controls :: Date Wise Search For A Date Filter?

Mar 16, 2011

How do i do implement this? i Wanna search records based on date!

View 8 Replies

Forms Data Controls :: Basic Date Picker Not Saving Date?

Jan 24, 2011

I'm using a basic date picker control in a gridview and using an sqldatasource, I don't get an error but the date selected is not saved only null is saved. why that might happen or make any suggestions on what I might try to correct this?

[Code]....

View 3 Replies

Forms Data Controls :: How To Calculate 60 Days From A Given Date And Show That Date

Jun 15, 2010

I have a formview. Inside, there is a textbox where user can input a date(txtAccepDt). Then the user will choose one item from a radiobutton list which has values like 60 days, 90 days and 150 days. If the user select the 60 days I need to add that to the Accept date and show it in a abel(lblShowFrstOp). Same will apply with other two day

View 4 Replies

Web Forms :: Validate Date In TextBox Greater Than Or Equal To Current Date?

Sep 5, 2013

validation to check the date  greater and equal to the current date .

View 1 Replies

Web Forms :: How To Display Full Month Name With Date And Year In Date Format

Aug 5, 2013

I want to display the current month name,date and time like this "August 5, 2013 06:30:58 pm" using ajax. 

View 1 Replies

Web Forms :: DropDownLists - Populate Three Month Prior Date When Date Is Selected?

Mar 20, 2013

i need a requirement of date range should be of 3 months only i.e,the first month,year are selected automatically the second month should be of 3 months after the first month.

ex:

FROM month is jan is selected. To month should be march.

as that the data range selected in SBI where between 6 months.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved