5 different overloads of Dataadapter.Fill() Method

5 different overloads of Dataadapter.Fill() Method

 

 

that Dataadapter is working just like a bridge between a datasource and dataset. One of the method of Dataadapter is Fill() Method. 

It can be overloaded in 5 different ways. 

Objective

I have tried here to clearly explain, how this Fill() method can be used in 5 different ways.

First Overload

Dataadapter.Fill(ds) here fetches the data from tblMobile and fills in the DataSet ds. 

Output

On clicking the button Fill DataSet, the dataadapter fills the dataset and finally,  the GridView shows all the records present in the dataset ds.

Second Overload

Here Dataadapter.Fill(dt) fetches records from tblMobile and fills in the datatable named dt.

Output

On clicking the button Fill DataTable, the dataadapter fills the datatable and finally Gridview displays all the records present in the datatable.

Third Overload

Here a datatable named nameOfDataTable has been filled by the dataadapter.Fill() method. As this datatable is within the dataset, we can use the commented line also to fill the gridview. Let me be clear here, 

To set the datasource of the gridview control we can use:

1. ds.Tables[0]     //valid
2. ds.Tables["nameOfDataTable"]    //valid

As this is the first table of the dataset, so we can use ds.Tables[0], otherwise we can use the table name to indicate which table i need to access.

Output

Fourth Overload

This overload takes 3 parameters. The types of parameters are int,int and datatable. Here first parameter is the starting record, second parameter is the maximum number of record and the last parameter is the datatable where we have to fill the records. The range from which the records are to be fetched are mentioned here using the parameters.

Output

Fifth Overload

At last, this overload takes 4 parameters. The types of parameters are dataset,int,int,string. The first parameter is the name of the dataset, second parameter is the starting record number, third parameter is the maximum number of records and the last parameter is the name of the table.

At first ds1 is filled with all the records of tblMobile. And then, dataadapter.Fill() method has filled the datatable nm with the specified range of records.

Following figure shows the contents of dataset ds1. It is having all the records of tblMobile.

Now, the dataadapter object da1 takes 4 parameters and fills the datatable named nm with the records of specified range.

Output

Hope this article was useful, thanks

Happy reading !