DataSet or DataTable Update

[pdh12783]

Hi All,

Language:-VB .NET

Hi i am using the following method to retrieve values from the database..

DSRs.Tables(0).Rows(AbsolutePosition).Item(sFieldN ame)
where DSRs =DataSet ,AbsoulutePosition is the record pos, sFiledName is the name of the column in databse..

Now the Problems is as follows:-

In the First method i am retrieving the data from the column as "EmpNAme".Suppose i get the result as David.. Now e.g. from the external source i modify that name to be "David1" .either manually from the database or from the Update statement executed directly in the databse..

Now without disconnectinog this dataset how do i update or refresh the DataSet or DataTable so that i can retrieve the updated valued. from the database.

Any help on this will be highly appreciated.

Thanks in Advancee,

Prashant Hirapara

[kenobewan]

Have you tried refilling the dataset using the data adapter?

[pdh12783]

yes i have tried the following statement to fill the dataset

DARs.Dispose()
DARs = Me.OpenDataAdapter(sSelectString)
Me.FillDataSet(DARs, DSRs, "Temp")

Where DaRs is the Data Adapter,sSelectString is the sql statement,

DsRs is the dataset.

Thanks ,

Prashant Hirapara

[kenobewan]

And you do this after the update, refill your dataset?

[pdh12783]

And you do this after the update, refill your dataset?

HI Thanks a lot mod...it has worked fine.. but i was afraid on using that as i thought that on the large queries it is not a good idea to refill the whole dataset.. as we dont do in vb 6.

Thanks and Keep Helping,

Prashant Hirapara