complete .net tutorials

Dataset : Dataset is nothing but a collection of datatables and it is used to managing the operations of a datatables.

you can use dataset by two ways , One is by using Dataset template and Second way is Systsem.Data Namespace

Firstway :

select solution explorer and add new item -> choose Dataset under Data

After Click the ServerExplorer and choose ConnectToDatabase icon

I thought you people might have great idea how to give connections in the Adddatabase dialog box

Next you can able to find Database and their datatables what you given at Add database template

Drag Any table into Dataset Area

After it , Save and Build once your project, Because of Dataset load your table.

come to the code at .aspx.cs side , perform your code for insert query to the selected table without mension any connection and command on the coding page

Now you can find Insert built in insert command for this selected table "City_population is the table name" and it display list of datacolumns in the method intelligence part

For code 

Check your database and datatable..Data will be added into your datatable.

Next Article will explain how add your own Query to the Dataset and later sections will give explicit ways of dataset usage, Which means how to add dataset by programtically and how perform these actions by using native c#.net.....................................................................................

                                                                                                                 Happy-Coding with m@ruthi.