Rebind CommandText Asp.net C#

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

Contributors

Replies

Views

7 Years

Discussion Span

7 Years Ago

Last Post by rahulkrishnanr

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?

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.

Edited 7 Years Ago by rahulkrishnanr: n/a

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

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

asp.net c# command sql text

<html> <head> <script type="text/javascript" src="fusioncharts/js/fusioncharts.js"></script> <script type="text/javascript" src="fusioncharts/js/themes/fusioncharts.theme.fint.js"></script> <script type="text/javascript" src="fusioncharts/js/themes/fusioncharts.theme.fint.js"></script> </head> <body> <script type="text/javascript"> FusionCharts.ready(function() { ...