How can Create Dataset and Sql Data-Adapter using through Menu in Disconnected Architecture

Dataset:-  Dataset is a cache memory where data resides. To represent this cache memory we have Dataset class which resides within System.Data Namespace.One Dataset can contain more than one tables.In windows application Sql Data-adapter and Dataset can be created either through menu or by writing the code.Here we are discussing how to create Sql data-adapter and Dataset using through Menu.

There are some steps to configure the Sql Data-Adapter and Dataset Using through Menu.

Step1:- First Create a Form (form1.cs)  through windows forms application in visual studio 2010.
see it:-

Step2:- Now open the Toolbox-> Right click on Toolbox-> Click Choose Items->Checked- the Sql Data Adapter check-box -> click ok.
See it:->

Step3:- Now Drag and Drop Sql Data-Adapter From the Toolbox-> one Wizard will be open.
see it:-

• Now click New Connection Button-> Enter Server name and Database name-> click ok.
• Now click Next Button->Choose use SQL Statement check box-> click Next Button ->now write the SQL Commands Which you want(select*from student)-> click  Next  Button  ->click Finish.

see it:-

Step4:- Now Drag  and Drop Dataset  control from Toolbox->Click OK Button.
see it:-

Step5:- Now Drag and Drop Data Grid-view control from Toolbox->Write the code on Form load to show the Dataset value to the Grid-view control.
see it:-

Step6:- Now Run the Application (Press F5).
OUTPUT:-

For More:-

1. Create Dataset and Data Adapter using coding
2. Generate Captcha image
3. Web Forms Controls
4. File Handling Real Application
5. oops concepts

I hope this is helpful for you.
To Get the Latest  Free Updates Subscribe
If any problem, please ask immediately.