we have mapped the dataset with SQL Server and updating the DataSet , now requirement is we have to
filter few data and dont want to update that Data in DataSet.
i am looking for the Script to update the DataSet from the DataBase Based on the SQL Query Condition.
Thanks In Advance!!
What I understood from your question is that you have a database table and you want data from that table in your dataset but only some filtered rows.
To implement this, instead of the Data Source as Database, you have to select "Script".
Then you can write C# or VB code to write your SQL query with 'where' condition to get selected rows.
Below is a sample script (for Vendor dataset) that you can refer:
Hope this resolves your query!
Thanks Its worked ,
But just want to know , i have enable the option operator can edit and add the records in the dataset .
but seems that option is not available when we are testing it through verification.
is there any limitation when we use the script in place of database.
Please sign in to leave a comment.