• »
  • Dataset Part2: Keep Your own query at Dataset Template

Dataset Part2: Keep Your own query at Dataset Template

Posted by : my solutions Wednesday, September 11, 2013

This Article will explain small extension of Dataset Template to write our own query at Adapter Design method

Select the Table and RightClick of the top of table and choose ADD->Query

Choose "Use SQL Statements"

Select Any one among of them and next ->
By Default it will display Basic Insert SQL Query. You can Erase this Query and Write your Query . You can Write your own Query by using 'QueryBuilder'
Give Your query Name here

Finally Finish it with next button with summary

Save and build once to load Dataset 
Check the code at once with your given queryname..By specification and Write down code as below..

Test at once in your sqlserver and you will able to see the values in your datatable.

------------------------------------------------------------Happy Coding with----m@ruthi

Leave a Reply

Subscribe to Posts | Subscribe to Comments

- Copyright © complete .net tutorials - Skyblue - Powered by Blogger - Designed by Johanes Djogan -