Date Problem
-
In sqlserver Database,datatype is smalldate/time and i tried following code Dim dtmDate As Date dtmDate = Date.Parse(TxtDat.Text) Response.Write("dtmdate") But it is giving String is not a valid datetype.How to format it examctle to isert into database. I need to isert only date not with the time. Help me out.please
kissy
-
In sqlserver Database,datatype is smalldate/time and i tried following code Dim dtmDate As Date dtmDate = Date.Parse(TxtDat.Text) Response.Write("dtmdate") But it is giving String is not a valid datetype.How to format it examctle to isert into database. I need to isert only date not with the time. Help me out.please
kissy
Try this. Date.Parse(TxtDat.Text).ToString("dd/MM/yyyy")
Thomas
-
Try this. Date.Parse(TxtDat.Text).ToString("dd/MM/yyyy")
Thomas
It is giving an errot that String was not recognised as valid Date. Give me solution,i Have used as below Dim dtmDate As DateTime dtmDate = Date.Parse(TxtDat.Text).ToString("mm-dd-yyyy") Response.Write("dtmdate") Here i am taking date from Calender. How to solve this,Thanks for ur answer
kissy
-
It is giving an errot that String was not recognised as valid Date. Give me solution,i Have used as below Dim dtmDate As DateTime dtmDate = Date.Parse(TxtDat.Text).ToString("mm-dd-yyyy") Response.Write("dtmdate") Here i am taking date from Calender. How to solve this,Thanks for ur answer
kissy
Your date format string is wrong. Use capital ‘M’ in the place of month. Like this "MM-dd-yyyy"
Thomas
-
Your date format string is wrong. Use capital ‘M’ in the place of month. Like this "MM-dd-yyyy"
Thomas
-
But eventhough i changed it is givig the same error.Where exactle i have to change the format,or else give me anothe idea
kissy
-
You pass value in text box in mm/dd/yyyy format and you can display that value by following code stdate = DateTime.Parse(TextBox1.Text) Response.Write(stdate.ToString("dd MMM yyyy")) so if you pass 10/26/2006 it will display 26 Oct 2006 you can change format of date but you have to pass date in textbox in mm/dd/yyy format Try it :)
-
You pass value in text box in mm/dd/yyyy format and you can display that value by following code stdate = DateTime.Parse(TextBox1.Text) Response.Write(stdate.ToString("dd MMM yyyy")) so if you pass 10/26/2006 it will display 26 Oct 2006 you can change format of date but you have to pass date in textbox in mm/dd/yyy format Try it :)
Dim stdate As DateTime = DateTime.Parse(TxtDat.Text) Dim strdate As DateTime = stdate.ToString("dd MM yyyy") and i am trying to isert this strdate valued into my smalldatetime datatype value in database.Then it is giving error that cast from 26 10 2006 to Date is not valid.Waht exactle i have to insert into my database for insertion of Date column.Like 26/10/2006
kissy
-
Dim stdate As DateTime = DateTime.Parse(TxtDat.Text) Dim strdate As DateTime = stdate.ToString("dd MM yyyy") and i am trying to isert this strdate valued into my smalldatetime datatype value in database.Then it is giving error that cast from 26 10 2006 to Date is not valid.Waht exactle i have to insert into my database for insertion of Date column.Like 26/10/2006
kissy
Dim strdate As DateTime = stdate.ToString("dd MM yyyy") this will never work kissy. as you are converting string into datetime so dont do that. instead you pass value when you are inserting it into database. and dont worry abot smalldatetime datatype it will take any value of date. so try to insert it as it is. and then let me know the changes Try it:)
-
Dim stdate As DateTime = DateTime.Parse(TxtDat.Text) Dim strdate As DateTime = stdate.ToString("dd MM yyyy") and i am trying to isert this strdate valued into my smalldatetime datatype value in database.Then it is giving error that cast from 26 10 2006 to Date is not valid.Waht exactle i have to insert into my database for insertion of Date column.Like 26/10/2006
kissy
Hi Kissy, I was having the sme problem, before few months, I could get the right solution. The only thing you need to do is copy paste the below code in your Page_Load. CultureInfo ci = new CultureInfo("de-AT"); Thread.CurrentThread.CurrentCulture = ci; You will have to import System.Threading and System.Globalization in Import section This is nothing but setting up Dutche culture, so that your date format is fixed to dd/MM/yyyy format. While selecting from a calendar you may have to give SelectedDate.ToString.Replace(".","/") because it dispalys date in dd.MM.yyyy format. Cheers Sony Sebastian
-
Dim strdate As DateTime = stdate.ToString("dd MM yyyy") this will never work kissy. as you are converting string into datetime so dont do that. instead you pass value when you are inserting it into database. and dont worry abot smalldatetime datatype it will take any value of date. so try to insert it as it is. and then let me know the changes Try it:)