Hello everyone, Here LogInTime and LogOutTime are datetime datatype. How to solve this error? AccessDate = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortDateString() : "Unknown" , AccessTimeFrame = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortTimeString() : "Unknown" ,

Never ever use ToShortDateString(), etc. These functions are dependent on machine's regional settings which you should never rely on because once deployed on another machine, it will start returning another value. Instead, use something like . ToString("yyyy-MM-dd") which would return reliable value. Try this.

It may be your data present is different form than format in SQL query. Please follow below links: http://stackoverflow.com/questions/13020611/how-to-select-rows-by-date-in-sqlite http://stackoverflow.com/questions/2309227/sqlite-select-with-condition-on-date

@Manas Mohapatra, Thanks for replay me. I got answer. Those variable were string format, now changed as Datetime datatype then show error like datetime conversion error. Now its solved AccessDate = DateTime.Parse(x.LogInTime.ToString()).ToShortDateString(), AccessTimeFrame = DateTime.Parse(x.LogInTime.ToString()).ToShortTimeString(), But I have a another question. I am using ADO.NET for SQLite DB select query. After excute this query return null. But there is data exist. The LogInTime is datetime format in SQLite DB. How can I solve this? sql = "SELECT * FROM Tble_UserSetUp inner join Tble_Login on Tble_UserSetUp.Id = Tble_Login.UserId WHERE Tble_Login.UserId='" + UserID + "' and CAST(Tble_Login.LogInTime AS date) ='" + AccessDate + "' or CAST(Tble_Login.LogOutTime AS date) ='" + AccessDate + "'" ;

Answers

datetime error in C#

Mani Kandan

252

Hello everyone,

Here LogInTime and LogOutTime are datetime datatype. How to solve this error?

AccessDate = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortDateString() : "Unknown",
AccessTimeFrame = (DateTime.TryParse(x.LogOutTime, out parsed)) ? parsed.ToShortTimeString() : "Unknown",

Answers (4)

i call applet at master page

<applet style="margin-top: 0px" height="20" width="950" align="top" code="Ticker.class"
                        codebase="abcd ">
                        <param name="BUTTONLAYOUT" value="links" />
                        <param name="YKORR" value="0" />


                        <param name="BUTTON3ANZEIGEN" value="0" />
                        <param name="BUTTON4ANZEIGEN" value="0" />
                        <param name="BUTTON5ANZEIGEN" value="0" />
                        <param name="DELAY" value="15" />


                        <param name="IDLE" value="60" />
                        <param name="RICHTUNG" value="LINKS" />
                        <param name="TICKERDATEI" value="path of text file" />
                        <param name="BMP_LINKS" value="" />
                        <param name="BMP_RECHTS" value="" />
                        <param name="BMP_GO" value="" />
                        <param name="BMP_STOP" value="" />
                        <param name="BMP_HOCH" value="" />
                    ..................................
................................

                    </applet>

I think if you can do it by manually then using that code also it should work.
Probably I need to check your pageload code.....

Are you facing any problem to refresh the page with that code?

i used this but problem is still same.........

If you made any changes in textfile you need to refresh the page because the page is loaded before with old set of data. If you made any changes in textfile it will not aware of that untill you refresh it manually.
You can use the folllowing code in <head></head> tag to refresh the page automatically.
<head id="Head1" runat="server">

<meta http-equiv="Refresh" content="5">
</head>
Note: I have given content value is 5. So after every 5 second it will refresh the page. You can increase or decrease the time frame.

i tried it but not solved.
actually i use applet for ticker.
data in ticker coming from text file when i make changes in text file chnaged data not reflecting immediately it reflected after browser refresh.

Try this code to clear the cache:
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Expires = 0;
Response.ExpiresAbsolute = Convert.ToDateTime(DateTime.Today.AddDays(-1));
Response.AddHeader("pragma", "no-cache");
Response.AddHeader("cache-control", "private");
Response.CacheControl = "no-cache";

use Timer to overcome this problem.

void Timer_Tick()
{
call the function to be refreshed.
}

put the Ticker control in the Update Panel and write the code to be refreshed in the Timer Tick event as shown above.

your problem will get solved.

Next Recommended Forum

Function calculate the Period of team

Where do I put my business logic in mvc?

Forum Statistics

Please welcome our newest member Shore Light.
2,381,278 users have contributed to 122,524 threads and 389,030
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'What is SQL Server'.

Upcoming Events

View all