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

By
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.

1 comment:

  1. Woah! I'm really enjoying the template/theme of this blog. It's simple, yet effective.
    A lot of times it's very difficult to get that "perfect balance" between usability and visual appearance. I must say you have done a amazing job with this. Also, the blog loads extremely fast for me on Safari. Exceptional Blog!

    Stop by my web-site ... więcej

    ReplyDelete

Powered by Blogger.