You need to set the correct time zone for the web application. From Central Admin go to Manage web applications, highlight the one you want and select general settings in the ribbon bar. I know the language. I've read a book. - _Madmatt

Try this string sURL = Request.Url.AbsolutePath; thatraja |Chennai|India| Brainbench certifications Down-votes are like kid's kisses don't reject it :-) Do what you want quickly because the Doomsday on 2012 :-)

Thanks for your reply. It works for me ;) G. Satish

How does this related with ASP.NET ? Cheers ! Abhijit My Blog : http://abhijitjana.net

Thanks Mark, Can you please let me know, how can we create these ISAM files. G. Satish

It is not overriding M1, it is implementing it for BOTH interfaces. If you wanted, you could also explicitly implement it for each interface (so that casting it as Inf1 and calling M1 will do something different than casting it as Inf2 and calling M1). [Forum Guidelines]

Right having thought about this a bit more, I realize my pseudo code was a bit off. You're close though, you just need to split _mainstr into an array too then iterate through that and iterate through your _substr array too so: Loop through _mainstr array Within each loop, loop through _substr array and see if it's there, if so, add to holding object. Holding object at the end = matched items in the original order.

Yes. I tried now by using Server.MapPath(). But still same problem loosing sessions and static variables becoming null. G. Satish

You don't need to write a custom httphandler for this. Handle the Application_Error event in the global.asax and redirect to catch the unhandled exceptions. How are you trying to redirect in your try/catch blocks? I know the language. I've read a book. - _Madmatt

Find which process is using it and kill that process. "No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem

Thank You. It works fine G. Satish

Your data? What do you mean your data? :-D

How complex are your queries? If you don't need stored procedures or sub-queries then you could use SQL Compact Edition and encrypt the database. You would need to encrypt the connection string in your app config during the install.

Thanks for the 1 vote! So I found an error in my code. But I think 1 is too hard! public static bool IsFirstCharDigit(string szYourString) { if((szYourString != null) && (szYourString.Length > 0)) return char.IsDigit(szYourString[0]); return false; } or public static bool IsFirstCharDigit(string szYourString) { if(!string.IsNullOrEmpty(szYourString)) return char.IsDigit(szYourString[0]); return false; } Greetings Covean

If you place a wrapper to all the tr's it will load easily in XMLDocument / XDocument. Just take the table tag which wrap around all the entries. Use XElement.Load(your html string) to get the xml loaded. Now search the elements using Linq to XML. Cheers... Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution. My Latest Articles-->** Simplify Code Using NDepend Basics of Bing Search API using .NET Microsoft Bing MAP using Javascript

It seems a bit weired problem. Check the ODBC configuration for all the available drivers, and check whether the Microsoft Text Driver is installed on the machine or not. You will find the ODBC Datasource ADministrator from Administrative Tools.

Good day Satish Becacause of time i have, i will not write you a solution , but i will point to a problem First you use one variable to do all things. Why do you create one variable that will hold the SQl statement and one to store the results and evauate the result. i think you know what you are doing but you get confused by your code. declare another variable to hold the results after that you must test for only nulls and remove the quotes and try it like this DECLARE @Result VARCHAR(MAX) DECLARE @Final_Res VARCHAR(MAX) Set @Result = (SELECT TOP 1 WITH TIES theCol FROM (SELECT * FROM Tbl_Origin WHERE Zip_Final =@Zipcode ) AS t1 UNPIVOT (theValue FOR theCol IN (@Querystr)) AS u1 ORDER BY theValue DESC) IF @Result IS NULL Set @Result = 'Select Top 1 theCol from Tbl_Origin' else select @Result Hope this Helps Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Hi,I hope i understood you good enought. Here is TSQL solution which I hope will works for you. select * from mytable declare @zip as int set @zip = 123 declare @white as varchar(100) set @white =(select white from mytable where zip=@zip) declare @black as varchar(100) set @black =(select black from mytable where zip=@zip) declare @green as varchar(100) set @green =(select green from mytable where zip=@zip) create table #temptable (valstr varchar(100),colname varchar(100)) insert into #temptable values (@white,'white') insert into #temptable values (@black,'black') insert into #temptable values (@green,'green') declare @colname as varchar(100) set @colname=( select top 1 colname from #temptable order by valstr desc ) drop table #temptable declare @selectquery as nvarchar(max) set @selectquery ='select '+@colname+' from mytable where zip='+cast(@zip as varchar(10)) exec(@selectquery) I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

ya, i got the answer. By converting to string as Pctmatch.ToString("N2"); G. Satish

Simplier and better. 5 from me. Greetings - Jacek Gajek