Rebind CommandText Asp.net C#

Question

8 Years Ago

Hi Friends,

How can I change the Command Text based on a Control event like clicking a button? I want to change the sql query on clicking a button.

Any help is appreciated.

Thanks in advance

asp.net command sql text

2 Contributors
4 Replies
14 Views
8 Years Discussion Span
Latest Post 8 Years Ago by rahulkrishnanr

laghaterohan · Answer 1 · 2010-08-14T11:23:00+00:00

Hi,

Why u need to change a query altogether ? Instead why dont write a different method? Or use the concept of method overloading / method overriding as the case may be...?
Can u please elaborate?

rahulkrishnanr · Answer 2 · 2010-08-14T11:30:38+00:00

Thanks for the quick reply.

I have a dataset which will get loaded in the Cache when I click on Button_1. And when I Click on Button_2 I need another query to be executed and return data from the cache. This is my requirement. Please help.

laghaterohan · Answer 3 · 2010-08-14T11:34:27+00:00

You can write a different query on the click of Button_2 which retrives the data from cache?? Will this wont work?

rahulkrishnanr · Answer 4 · 2010-08-14T11:43:54+00:00

You can write a different query on the click of Button_2 which retrives the data from cache?? Will this wont work?

I had a lots of search which did not help me to come up with a solution for retrieving the data from cache. If you could post a sample code that will be truly helpful.

Thanks