ASP.NET

Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 2:41

i'm not sure, try commenting out bits of code and see what happens then you might find the line of code that is causing the problem, then post that on the forum Smile | :)

salon5-Mar-08 23:53

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

5-Mar-08 23:53

I have used AJAX Calender control to select date and now i want to use this date which is going to send to the SQL Server2005 database for processing.
How can I convert the datetime from the text box i.e. in string format returned by AJAX calender control to ASP.NET2.0 DateTime so that I can pass this to SQL Server2005?

Thanks in Advance

Laddie5-Mar-08 23:57

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

5-Mar-08 23:57

ASP.Net dateTime ???... You can convert a text to DateTime by writing

DateTime.Parse(string);..In your case DateTime.Parse(txtDateBox.Text) or something.

Thanks
Laddie

Kindly rate if the answer was helpful

salon6-Mar-08 0:02

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:02

I have used
1) DateTime dateFrom = DateTime.Parse(txtFromDate.Text.Text);
2) DateTime dateFrom = DateTime.Parse(txtFromDate.Text,System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat);
3) DateTime dateFrom = Convert.ToDateTime(txtFromDate.Text.Text);
4) DateTime dateFrom =(DateTime)txtFromDate.Text.Text;

But these all are not working.........

giving error

String was not recognized as a valid DateTime. Frown | :(

But when I hardcode the date as
DateTime dateFrom = new DateTime(2008, 2, 28);
it works perfectly.....

Laddie6-Mar-08 0:10

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:10

What is txtFromDate.Text.Text ?. It should be only txtFromDate.Text. And are you getting this error from after you execute the query or while converting ?..

You may try changing dateFrom to dateFrom.ToShortDateString() before inserting to DB if the error is from the second case.Just to ensure that it trims off the time part.

Thanks
Laddie

Kindly rate if the answer was helpful

salon6-Mar-08 0:18

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:18

Hey it was typographical mistake here but i have wrote txtFromDate.text in the code

salon6-Mar-08 0:25

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:25

It was getting error while passing to the query i.e. before going to the database

and it works fine with
DateTime dateFrom = new DateTime(2008, 2, 28);

Laddie6-Mar-08 0:43

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:43

No idea why it does't work..But as a work around send it as a string tot he DB. DB can convert it to Date time format

Thanks
Laddie

Kindly rate if the answer was helpful

Paddy Boyd6-Mar-08 1:16

Paddy Boyd

6-Mar-08 1:16

What is the string value in the textbox?

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

Christian Graus6-Mar-08 0:14

Christian Graus

6-Mar-08 0:14

bhavna816 wrote:
ASP.NET2.0 DateTime

First of all, there is no such thign. ASP.NET is a framework that generates HTML. You want to know how to create a datetime, which is a class in the .NET framework.

Second, you say that DateTime.TryParse is not working, what string are you passing it, and what do you mean by 'not working' ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

salon6-Mar-08 0:54

Re: Convert AJAX Calender Control's datetime to ASP.NET2.0 DateTime

6-Mar-08 0:54

I am passing the string which i get from the text box control which is the TargetControlID for AJAX calender control.

salon6-Mar-08 18:20

6-Mar-08 18:20

Thanks everybody for replying the problem is solved........... Big Grin | :-D

gridview count rows

eyeseetee5-Mar-08 23:17

5-Mar-08 23:17

Hi
I have a textbox which users enter search criteria into

When they hit a button a gridview will display any results that are found

however if no results are found I want to display a message

I have got

if (GridView4.Rows.Count < 1)
{
lbsearchcriteria.Text = "No results found";
}

but this if statement doesnt seem to work

any clues would be great

thanks

Laddie5-Mar-08 23:22

5-Mar-08 23:22

1) Have to turned off the Visibility to false ?
2) If you are using Ajax and update panel ensure both search button , grid and label are in the same update panel.

Thanks
Laddie

Kindly rate if the answer was helpful

eyeseetee5-Mar-08 23:58

5-Mar-08 23:58

well its just not reading the if statement because i have this:

if (GridView4.Rows.Count < 1)
{
lbsearchcriteria.Text = "No results found";
}
else if (GridView4.Rows.Count > 0)
{
do something
}

but it performs the second if statement even if no rows are displayed
is the if statement incorrect?
thanks

Laddie6-Mar-08 0:06

6-Mar-08 0:06

No..But why you require another if after else

if (GridView4.Rows.Count < 1)
{
lbsearchcriteria.Text = "No results found";
}
else
{
do something
}
This is same right ?.
May be you can try this ?(Dont ask me the thought behind it Wink | ;)

)

if (GridView4.Rows.Count > 0)
{
do something
}
else
{
lbsearchcriteria.Text = "No results found";
}

Thanks
Laddie

Kindly rate if the answer was helpful

eyeseetee6-Mar-08 0:54

Not able to write to C:\WINNT\Temp folder

6-Mar-08 0:54

ok thansk i will try that
cheers1 Big Grin | :-D

giri_jazz5-Mar-08 23:16

giri_jazz

5-Mar-08 23:16

Hi All,

My .net application automatically creates .tmp files, and are written to c:\winnt\temp folder. Now when the users access the application, they also shd be having the permission to c:\winnt\temp folder of server to allw writing .tmp files, or else will get error as Compiler Error Message: CVT1108: cannot open C:\WINNT\TEMP\RES4F42.tmp for writing. After manually giving authenticated users 'Write' Permission to C:\WINNT\TEMP\, Application runs perfectly.

This is only a temp soln, after sometime the the c:\winnt\temp folder will not allow authenticated users to write (the write permission would have been unchecked automatically).

Is it possible to redirect .tmp files to different folder other than c:\winnt\temp

Any suggestions please..

Girija

Laddie5-Mar-08 23:24

5-Mar-08 23:24

Add this lines

using System.Security.Permissions;
.
.
.

[assembly: FileIOPermission(SecurityAction.RequestMinimum,Unrestricted=true)]
class test
{
}

Thanks
Laddie

Kindly rate if the answer was helpful

giri_jazz6-Mar-08 0:03

giri_jazz

6-Mar-08 0:03

Hi,

We can't find out which pages writes to c:\winnt\temp folder, in that case how can I include the above code application level.

Thanks,
Giri

Laddie6-Mar-08 0:14

6-Mar-08 0:14

In that case you will have to use CasPol utility that comes with .net Frame work to provide permissions to your assembly.

Thanks
Laddie

Kindly rate if the answer was helpful

Paddy Boyd6-Mar-08 1:17

Paddy Boyd

6-Mar-08 1:17

How does it 'automatically' create temp files. Can you not just change this code to output to a different directory?