Q: Copying part of a table

[G .Net]

Hi

I'm wondering if anybody can help me with the following problem?

I have a table with several rows. I want to create a new table, with exactly
the same structure, but has only a subset of the rows in the original table.

I have been able to do this using the following code but wonder if there is
a more efficient/fast way of doing it.

Dim subsetTable As DataTable = sourceTable.Clone()

For Each row As DataRow In sourceTable.Select("[Name] = 'John'")
Dim newRow As DataRow = subsetTable.NewRow()
For i As Integer = 0 To sourceTable.Columns.Count - 1
newRow(i) = row(i)
Next
subsetTable.Rows.Add(newRow)
Next

Using the code above I can a new table which has all the rows from the
source table with the field "Name" set to "John".

Can anybody suggest a more efficient/fast way of doing this?

Thanks in advance

 

[Pritcham]

Hi

You can actually do this via SQL. If you use the "INSERT INTO myTable"
statement then it will add rows to an existing table, if you use
"SELECT INTO myTable" it will create the table first, then add the
details. Both of these can have a WHERE clause so you can filter
what's going in to the table.

Hope that helps
Martin

 

[G .Net]

Hi Martin

Good idea, but I don't think you can do this via DataSets only - which is my
intention.

Hi

You can actually do this via SQL. If you use the "INSERT INTO myTable"
statement then it will add rows to an existing table, if you use
"SELECT INTO myTable" it will create the table first, then add the
details. Both of these can have a WHERE clause so you can filter
what's going in to the table.

Hope that helps
Martin

Hi

I'm wondering if anybody can help me with the following problem?

I have a table with several rows. I want to create a new table, with
exactly
the same structure, but has only a subset of the rows in the original
table.

I have been able to do this using the following code but wonder if there
is
a more efficient/fast way of doing it.

Dim subsetTable As DataTable = sourceTable.Clone()

For Each row As DataRow In sourceTable.Select("[Name] = 'John'")
Dim newRow As DataRow = subsetTable.NewRow()
For i As Integer = 0 To sourceTable.Columns.Count - 1
newRow(i) = row(i)
Next
subsetTable.Rows.Add(newRow)
Next

Using the code above I can a new table which has all the rows from the
source table with the field "Name" set to "John".

Can anybody suggest a more efficient/fast way of doing this?

Thanks in advance

 

[Guest]

G.Net,

In .Net 2.0 you can create a dataview of the original datatable, filter it
to contain only the rows you want, and then use the dataview's ToTable method
to create a new datatable containing only the rows from the filtered dataview.

Kerry Moorman

Hi Martin

Good idea, but I don't think you can do this via DataSets only - which is my
intention.

Hi

You can actually do this via SQL. If you use the "INSERT INTO myTable"
statement then it will add rows to an existing table, if you use
"SELECT INTO myTable" it will create the table first, then add the
details. Both of these can have a WHERE clause so you can filter
what's going in to the table.

Hope that helps
Martin

Hi

I'm wondering if anybody can help me with the following problem?

I have a table with several rows. I want to create a new table, with
exactly
the same structure, but has only a subset of the rows in the original
table.

I have been able to do this using the following code but wonder if there
is
a more efficient/fast way of doing it.

Dim subsetTable As DataTable = sourceTable.Clone()

For Each row As DataRow In sourceTable.Select("[Name] = 'John'")
Dim newRow As DataRow = subsetTable.NewRow()
For i As Integer = 0 To sourceTable.Columns.Count - 1
newRow(i) = row(i)
Next
subsetTable.Rows.Add(newRow)
Next

Using the code above I can a new table which has all the rows from the
source table with the field "Name" set to "John".

Can anybody suggest a more efficient/fast way of doing this?

Thanks in advance

 

[G .Net]

Thanks Kerry. Very interesting.

G.Net,

In .Net 2.0 you can create a dataview of the original datatable, filter it
to contain only the rows you want, and then use the dataview's ToTable
method
to create a new datatable containing only the rows from the filtered
dataview.

Kerry Moorman

Hi Martin

Good idea, but I don't think you can do this via DataSets only - which is
my
intention.

Hi

You can actually do this via SQL. If you use the "INSERT INTO myTable"
statement then it will add rows to an existing table, if you use
"SELECT INTO myTable" it will create the table first, then add the
details. Both of these can have a WHERE clause so you can filter
what's going in to the table.

Hope that helps
Martin

G .Net wrote:
Hi

I'm wondering if anybody can help me with the following problem?

I have a table with several rows. I want to create a new table, with
exactly
the same structure, but has only a subset of the rows in the original
table.

I have been able to do this using the following code but wonder if
there
is
a more efficient/fast way of doing it.

Dim subsetTable As DataTable = sourceTable.Clone()

For Each row As DataRow In sourceTable.Select("[Name] = 'John'")
Dim newRow As DataRow = subsetTable.NewRow()
For i As Integer = 0 To sourceTable.Columns.Count - 1
newRow(i) = row(i)
Next
subsetTable.Rows.Add(newRow)
Next

Using the code above I can a new table which has all the rows from the
source table with the field "Name" set to "John".

Can anybody suggest a more efficient/fast way of doing this?

Thanks in advance

 

[Cor Ligthert [MVP]]

G.

You can very simple use the overloaded new 2005 method from the dataview
ToTable for this.

I hope this helps,

Cor

 

[G .Net]

Thanks Cor

G.

You can very simple use the overloaded new 2005 method from the dataview
ToTable for this.

I hope this helps,

Cor

Hi

I'm wondering if anybody can help me with the following problem?

I have a table with several rows. I want to create a new table, with
exactly the same structure, but has only a subset of the rows in the
original table.

I have been able to do this using the following code but wonder if there
is a more efficient/fast way of doing it.

Dim subsetTable As DataTable = sourceTable.Clone()

For Each row As DataRow In sourceTable.Select("[Name] = 'John'")
Dim newRow As DataRow = subsetTable.NewRow()
For i As Integer = 0 To sourceTable.Columns.Count - 1
newRow(i) = row(i)
Next
subsetTable.Rows.Add(newRow)
Next

Using the code above I can a new table which has all the rows from the
source table with the field "Name" set to "John".

Can anybody suggest a more efficient/fast way of doing this?

Thanks in advance