|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
what are you passing in your text box??
I mean what exactly you want to do?
|
|
|
|
|
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 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
|
|
|
|
|
Thank you so much for clearing my doubt.
Here my mistake is in Calender i have used dd/mm/yyyy.
and now it is working properly,Thank you once again
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
|
|
|
|
|
textbox contain text with html tags and i want to save text with html tags in file called test.html when i click on save button.
when i remove html tags then file are save properly. but when i use html tags then an error occured.
so how can i resolve the problem.
text box contain this text.
<a>abc</a>
<p>hello</p>
<p><b>World</b></p>
how can i save this text a html file.
dcjoshi2
|
|
|
|
|
What is that error? Do u set the validateRequest="false" tag in the page directive?
Thomas
|
|
|
|
|
It can give two problems
1) Request validation failed, so you will have to give ValidateRequest="False" in <%@page %> directive.
2) if it gives error while saving into database or other, just give
Server.HtmlEncode(TextBox1.text)
|
|
|
|
|
how could i upload a file through ajax in asp.net 1.1.which will work in all the browser.pls give me a sample code.
tbhattacharjee
|
|
|
|
|
hello all ,
whene i write data in webapplication and i want to this dat6a to recording in the data base and this data are in arabic languag this data recorded in data base but the word which is arabic recorded lik this ??????? and i want the data bas to read the arabic languag
|
|
|
|
|
To store Arabic words in database, you must set the collation of database is to Arabic
Thomas
|
|
|
|
|
how to convert a string (textbox) to date format
rahul saini
|
|
|
|
|
Hi
you can convert string into date with help of Convert function
dim dt as DateTime
dim str as string = "12/12/2006"
dt = Convert.ToDateTime(str)
Then dt have value 12/12/2006
Enjoy....
|
|
|
|
|
hi
thanx 4 showing interesting.
i hav used (change.todatetime) but not satisfied with the result. i m using following code pls check.
Dim startDate As DateTime
startDate = Convert.ToDateTime(start_date.Text.ToString)
Dim endDate As DateTime
endDate = Convert.ToDateTime(end_date.Text.ToString)
If endDate > startDate Then
Return True
Else
Return False
End If
regards
rahul saini
|
|
|
|
|
yes it will perfectly run
|
|
|
|
|
no it is not working. following error is shown
"String was not recognized as a valid DateTime."
so please check it again
thanx
regards
rahul saini
|
|
|
|
|
what are you passing in your text box???
tell me exact value that you are passing in your text box
and no need to write .ToString after .Text it is by default string
|
|
|
|
|
i m passing. date in following format 26/10/2006
dat's it
regards
rahul saini
|
|
|
|
|
You have to pass date in mm/dd/yyyy format dear else it will give error
stdate = DateTime.Parse(TextBox1.Text)
Response.Write(stdate.ToString("dd MMM yyyy"))
try this code and pass 10/26/2006 in your text box it will display 26 Oct 2006 so you must pass date in mm/dd/yyyy format as by default it accept date in this format..
Ok so try it and let me know it is working or not
|
|
|
|