As a general rule, don't use functions or the LIKE operator on your table columns or your query won't use any indexes. The easiest way of speeding this query is by replacing this (I assume there's a typo and there is no '@' outside the COALESCE): WHERE empid LIKE COALESCE(CONVERT(varchar(3), @empid), '%') AND batchid LIKE COALESCE(CONVERT(varchar(3), @batchid), '%') for something like this: WHERE empid BETWEEN @firstEmpid AND @lastEmpid AND batchid BETWEEN @firstBatchid AND @lastBatchid And do a bit of math to calculate the first and last ids. If this filter returns a small result set, then the slowest part (show below) of the query won't need to run against a lot of records and the query will be way faster. AND name LIKE ('%' + @name + '%' Yes, even I am blogging now!

Poastback is also based on EnableViewState property of the Page. Bhaskara

Hi Paul, I just found a dirty way to do this. I put a normal button, a textbox and a file input field. Then put some java script and managed to call the file input's click event from the button's click event, so when I clicked the button the open dialog box would appear, and it worked!. Then the getting the text in to the text box from file input was easy. Now I can do what ever the decorations to the poor button :) Thanks for your help and your time. :) UB You may stop this individual, but you can't stop us all... after all, we're all alike. +++Mentor+++

Hi friend i am unable find the Sdk 2.5 for passport authentication Please tell me the procedure to find it and run the application All i got is windows live web authentication

Hi You could use Caledon Card services for your merchant account. They seemlessly integrate to your site or cart, and provide a virtual terminal to accept by phone or mail at no extra charge, and at the same low rate. www.caledoncard.com

Thank you very much for your help. I thought there's an easier way to do this without using a TypeConverter. I'll look in those sections in the .NET Framework SDK. Thanks for your time :) UB You may stop this individual, but you can't stop us all... after all, we're all alike. +++Mentor+++

Thanks for the advice. I found several articles on CodeProject. To make it borderless they have used subclassing. It's a war out there. Some of them have used hooks, and some of them are against using hooks :) By the way I went to geekcode.com, and now I know what's that first three letters mean :) Thanks again. UB You may stop this individual, but you can't stop us all... after all, we're all alike. +++Mentor+++