--Req : To Fetch Complete Records by using between op
Sales table with (datetimesampled datetime,total int)
2010-01-01 00:00:01.000 10
2010-02-01 13:00:01.000 20
2010-03-01 00:00:09.000 30
2010-04-01 00:00:01.000 40
2010-05-01 00:00:01.000 50
2010-06-01 00:00:03.000 60
2010-07-01 00:00:04.000 70
2010-08-01 23:59:01.000 80
select * from Sales where datetimesampled between '01/01/2010 ' and '08/01/2010 ' --fails to fetch 8 th date record
select * from Sales where datetimesampled between
convert(varchar(10),'08/01/2010 ') -- fails to fetch 8 th date record
select * from sales where datetimesampled between '01/01/2010
00:00:00.000' and '08/01/2010 23:59:59.000' --this works but i do not
want cocatenation as i use this query in c# file in SqlCommand
Could any please provide me the solution how to fetch complete records
View Complete Post
My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.
How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?
Or any other suitable alternate?
Reply fast kindly.
Thanks and regards.
i want to redirect the user from ?????the ??AuthenticateRequest in the global.asax file when session timeout ?happens.
is it possible.
I have hosted a retail web application in Godaddy, how to pick particular country time in asp.net.
Thanks in advance.
In my live site session time out with in 5 min only.how can i get the default i.e 20 min time . below webconfig file give below
<?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in \Windows\Microsoft.Net\Framework\v2.x\Config --><configuration> <configSections> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35"> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup,
I have used the above method to configure my crystal report ...
Its working fine , But i have huge number of data in database ....
So , it take long time to load the report ...
So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.
Plz help me with this issue ...
Also , Plz explain me abt index legend in crystal report.