Converting a Dataview into a Dataset

[Ramakrishnan Nagarajan]

Hi can any one help me in converting a DataView into a DataSet or a DataTable
into a DataSet,
I tried the following ways

dSet= ((DataSet)_grid RegStudDetails. DataSource);
dSet = ((DataSet)_grid RegStudDetails. DataSource).Tab les[0].DataSet;
studData = ((DataSet)dView ).Tables[0].DataSet;

But not working
can you pls help me out
Thanks in advance,
N.Ramakrishnan

[Marina]

Let's say your dataview's name is myDataView.

myDataView.Tabl e will return to you the underlying DataTable.
"Ramakrishn an Nagarajan" <ra**********@d iscussions.micr osoft.com> wrote in
message news:87******** *************** ***********@mic rosoft.com...

Hi can any one help me in converting a DataView into a DataSet or a
DataTable
into a DataSet,
I tried the following ways

dSet= ((DataSet)_grid RegStudDetails. DataSource);
dSet = ((DataSet)_grid RegStudDetails. DataSource).Tab les[0].DataSet;
studData = ((DataSet)dView ).Tables[0].DataSet;

But not working
can you pls help me out
Thanks in advance,
N.Ramakrishnan

[Cor Ligthert [MVP]]

Ramakrishnan.

A dataview holds no data.

However it holds (in Net 1.x) a reference to its datatable and in 2.0 it
will holds a reference to get its selected/sorted datarowviews.

Therefore what you want you can do in version 2.0. For 1.x you can use this
sample (what is not so much more work).

http://www.windowsformsdatagridhelp....7-d6ad9bebf57f

I hope this helps,

Cor

[Chris]

Ramakrishnan Nagarajan wrote:

Hi can any one help me in converting a DataView into a DataSet or a DataTable
into a DataSet,
I tried the following ways

dSet= ((DataSet)_grid RegStudDetails. DataSource);
dSet = ((DataSet)_grid RegStudDetails. DataSource).Tab les[0].DataSet;
studData = ((DataSet)dView ).Tables[0].DataSet;

But not working
can you pls help me out
Thanks in advance,
N.Ramakrishnan

You don't convert a datatable to a dataset. You add a table to a dataset.

From the help file under: DataSet Class, adding DataTable

Dim custDS As DataSet = New DataSet("Custom erOrders")

Dim ordersTable As DataTable = custDS.Tables.A dd("Orders")

Dim pkCol As DataColumn = ordersTable.Col umns.Add("Order ID",
Type.GetType("S ystem.Int32"))
ordersTable.Col umns.Add("Order Quantity", Type.GetType("S ystem.Int32"))
ordersTable.Col umns.Add("Compa nyName", Type.GetType("S ystem.String"))

ordersTable.Pri maryKey = New DataColumn() {pkCol}
Chris

[Ramakrishnan Nagarajan]

Hi,
Thanks to every one who have dropped their help for my post.
I have no problem at all in sorting the data in the grid.
At first the DataSet will contain the data from the DataBase. Am fetching
all the data from the DataSet and create a new DataTable along with the new
values entered by the user in the DataGrid. Then Inorder to sort the data am
casting it to a DataView and sorted. Then I am binding the DataView to the
Grid. At this point I want all the data in the DataView to be in the DataSet
for future reference by the same event. So to have all those data in the
DataView to be in the DataSet what can I do. Can you please help me out.
Thanks,
N.Ramakrishnan

"Cor Ligthert [MVP]" wrote:

Ramakrishnan.

A dataview holds no data.

However it holds (in Net 1.x) a reference to its datatable and in 2.0 it
will holds a reference to get its selected/sorted datarowviews.

Therefore what you want you can do in version 2.0. For 1.x you can use this
sample (what is not so much more work).

http://www.windowsformsdatagridhelp....7-d6ad9bebf57f

I hope this helps,

Cor

[Cor Ligthert [MVP]]

RamaKrishnan,

Did you see the sample the only thing you need at the end of that is somehow

ds.Add.Tables(d t)
or instead of that
dt = dtnew.copy
ds.Add.Tables(d tnew)

I hope this helps,

Cor

[Ramakrishnan Nagarajan]

Thanks Cor,
You are right and I did that using ds.Tables.Add(d t);
And now dataset is having the values of the datatable.
Thanks a lot again Cor.

N.Ramakrishnan

"Cor Ligthert [MVP]" wrote:

RamaKrishnan,

Did you see the sample the only thing you need at the end of that is somehow

ds.Add.Tables(d t)
or instead of that
dt = dtnew.copy
ds.Add.Tables(d tnew)

I hope this helps,

Cor