Really need help!!!!!!!
-
Hi all, I want to implement the sql cache dependency as shows in [This Article](<a href=) My problem is that in this example the cache data is shown on the web using SqlDataSource,Grid controls ,But i want to use this data in form of data table and dont wanna show the whole data. Can any one help me plzz. Best Regards
-
Hi all, I want to implement the sql cache dependency as shows in [This Article](<a href=) My problem is that in this example the cache data is shown on the web using SqlDataSource,Grid controls ,But i want to use this data in form of data table and dont wanna show the whole data. Can any one help me plzz. Best Regards
-
The link doesn't lead to an article. If you have a DataSet, you can use a DataView to filter the data. --- b { font-weight: normal; }
Ok in short i will tell u the problem. i am having a SqlDataSource control which i am binding to a gridview control.This SqlDataSource control i am using in my Sql Cache invalidation mechanism.(i am doin this coz ,i am unable to find any other way) My question is that i don't want to bind the data that is fetched by this SqlDataSource control to the GridView control,instead i want to consume the data in my code behind. SO IS THERE A WAY TO GET A DATATABLE FROM SQLDATASOURCE????? OR IS THERE ANY OTHER WORK AROUND???
-
Ok in short i will tell u the problem. i am having a SqlDataSource control which i am binding to a gridview control.This SqlDataSource control i am using in my Sql Cache invalidation mechanism.(i am doin this coz ,i am unable to find any other way) My question is that i don't want to bind the data that is fetched by this SqlDataSource control to the GridView control,instead i want to consume the data in my code behind. SO IS THERE A WAY TO GET A DATATABLE FROM SQLDATASOURCE????? OR IS THERE ANY OTHER WORK AROUND???
What are you SCREAMING about? It looks like your spilled too much stuff on your keyboard, the question mark seems sticky. I don't find much information about the SqlDataSourceControl class in the documentation. Of course you could consume the data source in some way, but I think that you would be better off using a regular SqlConnection and SqlCommand. Then you can get the data into a DataSet and use a DataView to filter the data. --- b { font-weight: normal; }
-
What are you SCREAMING about? It looks like your spilled too much stuff on your keyboard, the question mark seems sticky. I don't find much information about the SqlDataSourceControl class in the documentation. Of course you could consume the data source in some way, but I think that you would be better off using a regular SqlConnection and SqlCommand. Then you can get the data into a DataSet and use a DataView to filter the data. --- b { font-weight: normal; }
So Now atlast u came to know why i am SCREAMING about coz u were unable to find much information about sqldatasource as well. anyway thanks for reply coz the solution you are telling me seems CHILDISH.coz i have already mentioned that i could find no way of using regular databindings syntex using Sql Server Cache invalidation mechanism. all of the examples shows it by using SqlDatasource control. regards