Dbdataadapter filling (fill) Dataset

FillThe method supports the following situations:DatasetContains multipleDatatableObject, and the names of these objects are only case-insensitive. In this case,FillPerform a case-sensitive comparison to find the corresponding table. If no matching table exists, create a new one. The following C #CodeThis action is interpreted.

Dataset dataset = new dataset (); dataset. tables. add ("AAA"); dataset. tables. add ("AAA"); adapter. fill (dataset, "AAA"); // fills "AAA", which already exists in the dataset. adapter. fill (dataset, "AAA"); // adds a new table called "AAA ".

 

If you callFillAndDatasetContains only one name, which is case-insensitive.Datatable, UpdateDatatable. In this case, the comparison is case insensitive. The following C # code illustrates this behavior.

Dataset dataset = new dataset (); dataset. tables. add ("AAA"); adapter. fill (dataset, "AAA"); // fills table "AAA" because only one similarly named table is in the dataset