Thank you .it has solved partially but still have one problem If we have rows which are less than or equal for the supplied parameter(Date) we are pulling highest date row here this is working correct . if we don't have any rows which are less than or equal for the supplied parameter(Date) and if we have rows which are greater than supplied parameter we need to pull lowest date.can you help in this regard

Hi ,

ID Device id TimeZone Effective Date
1 123 CST 2017-01-07 00:00:00.000
1 123 PST 2017-06-24 00:00:00.000
1 123 MST 2017-08-02 00:00:00.000
2 345 CST 2017-07-01 00:00:00.000
2 345 PST 2017-08-01 00:00:00.000
4 678 CST 2017-08-02 00:00:00.000

The above table is Name Timetable .I looking for below result if i pass date parameter
as ‘2017-08-01 00:00:00.000’

ID Device id TimeZone Effective Date
1 123 CST 2017-01-07 00:00:00.000
2 345 PST 2017-08-01 00:00:00.000
4 678 CST 2017-08-02 00:00:00.000

Hi Experts i want to install share point 2010 can u please let me know what are the softwares that needs to be licensed .Do we need sqlserver 2008 r2 and share point 2010 or only sharepoint 2010 Thanks & regards venu

But i should pass the credentials in code and i should download a file instead of showing credentials to the user

Hi Experts, i want to download a file from Network with different domain with credentials of some particular user who has rights to access the file in destination computer.. for example i have a network system with ip:\\100.120.2.3 in that we have a file in d drive where it can be acessed by xyz user .Now my criteria is to download a file from that folder from my system by passing credentials of that particular xyz user in asp.net Regards venu

Hi Experts, i have a client system where share point is not installed i want to run a console application where i want to retrive the data from sharepoint and update the data of sharepoint list using webservices Regards venu

ya i dont have permissions to read it but i have a user name and password who has the permission to read so i have to pass this parameters in the code and to read the file

Hi Experts can u please guide me how to download a file which is in Network location( \\10.101.....)where we pass credentials OF particular server and downloading a file from that server to local Machine in asp.net Regards venu

Hi Experts can u please guide me how to download a file which is in Network location( \\10.101.....)where we pass credentials OF particular server and downloading a file from that server to local Machine in asp.net Regards venu

Dear experts good evening all i am Experiencing a serious problem i am exporting data table data into excel spread sheets .for some active directory users its works fine and it is able to export the data and there is no error .and for some people it is showing 403 error i have given full permissions please help me out Regards venu

Hai Experts I have done googlemap with single marker dynamically . i have tried same way for multiple marker where latitudes and longitudes comes from database .can u please suggest me How to approach. Regards venu

Hai nischalke. If u dont know The answer please keep quiet, or do your work..understood.I have seen many Answers From u which are not at all use ful Regards venu

Hai Experts. i am working on the slide shows for my webapplication .i need a Vertical slide Show that moves From bottom to top For Example http://www.accenture.com/us-en/Pages/index.aspx\[^\] Here they are showing in the horizontal way i need in The Reverse order Vertical with same Bttom move up and Move down please Help me out Regards venu

Hai Experts. i am working on the slide shows for my webapplication .i need a Vertical slide Show that moves From bottom to top For Example http://www.accenture.com/us-en/Pages/index.aspx[^] Here they are showing in the horizontal way i need in The Reverse order Vertical with same Bttom move up and Move down please Help me out Regards venu

hiren be cool try to think abt question and give answer .dont make comments on the question .

yes i know that u dont know .i posted my question once again becuse i dint get any reply.. ur answer is unjustified .any way guys iam sorry if iam rude

modified on Wednesday, December 15, 2010 9:49 AM

who the hell ru ... did i ask u to send me the code i know that u dont know .if u dont know keep quiet dont comment.. regards venu

hai experts i need a gauge control in asp.net with out third party tools is .can u please suggest me how to design a circular gauge control in asp.net .it is very urgent requirement please help me out Regards venu

hai experts i need a gauge control in asp.net with out third party tools is .can u please suggest me how to design a circular gauge control in asp.net .it is very urgent requirement please help me out Regards venu

hi christian. actually i used regualr expression for decimals like it will take it as only 100.20 but when the user enters 100 it shuld be conevrt as 100.00 or 200 it shuld convert as 200.00 etc