Hi all
I have a Dataset name: dsMain
I popullate with all the data from the database on form load event
I have a requirement to filter data as per users requirement on a button click event
What I want is that when the user clicks the button the program should query the Dataset table and not the database table and return the result
So basicly I want to know how can I use T-SQL statements on a Dataset table and get result.
If somebody can help me out with this and provide some examples of this will be of great help.
Regards,
Mayank
I have a Dataset name: dsMain
I popullate with all the data from the database on form load event
I have a requirement to filter data as per users requirement on a button click event
What I want is that when the user clicks the button the program should query the Dataset table and not the database table and return the result
So basicly I want to know how can I use T-SQL statements on a Dataset table and get result.
If somebody can help me out with this and provide some examples of this will be of great help.
Regards,
Mayank