HOW FILL A DATATABLE FROM THE DATASET ???

[Guest]

Hi,

I usually work with dataset I fill from SQL Server through a SQLDataAdapter.
I would like to fill a table of my dataset reading the records from another
table of the dataset, because I would like to change the order of the column
without reconnect to SQLServer. The first time I connect to import the
records through a parametric stored procedure stored in SQL Server.Is there a
specific dataadapter to read and fill datatable from the dataset control ???
Any suggest ???

Many thanks

 

[Sahil Malik [MVP]]

NQ,

You can fill a datatable directly using SqlDataAdapter.

Also, you can simply use the datatable directly (DataSet.Tables[index])

Regarding changing the order of the columns - well, you can easily change
that at databinding.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

 

[Cor Ligthert [MVP]]

NQ,

In version 1.x there was not the datatable.merge. Therefore I have two
methods to fullfil your problem. I used this method in 1.x.

http://www.vb-tips.com/default.aspx?ID=67b889fc-8593-4fcb-be92-fabbdffba809

In version 2.0 it is really very simple to do what you ask.

http://www.vb-tips.com/default.aspx?ID=7bcd765e-3090-4813-8baf-a0425125e213

I hope this helps

Cor

 

[Guest]

Many thanks...
I was looking for a way as the merge method You explain me will be present
in the 2.0 version.
At this time I'll try to loop through the rows and the columns of the table
and I'll giva a look to the datagrid styles too.... as You suggest me...

Thanks a lot...
Bye