Dataview into new table ???

[Sjaakie Helderhorst]

Hi,

I've come a stage that I'm feeling an absolute idiot.
Struggling with this issue for days and can't find a suitable answer.

Have this dataset which 'amount' value can be updated. Need to send all
records with 'amount > 0' to a webservice as a Datatable. (Ignorant as I
might be) I Dim a new DataView (rowfilter 'amount > 0') and copy this into a
new datatable:
dv = New DataView(ds.Tables("Items"), _
"amount > 0", _
"barcode", _
DataViewRowState.CurrentRows)

Dim dt As New DataTable("Result")
dt = dv.Table.Copy
sendDS.Tables.Add(dt)

However, sending this datatable (dt) to a webservice will send the entire
source dataset (= huge)

What am I doing wrong ...
Is there a more suitable way of achieving this!?

Thanks in advance.

[Martin Dechev]

Hi, Sjaakie Helderhorst,

Maybe you can send a new DataSet containing only the DataTable in question.

Hope this helps
Martin
"Sjaakie Helderhorst" <di*********@hotNOTmail.com> wrote in message
news:ui**************@TK2MSFTNGP09.phx.gbl...

Hi,

I've come a stage that I'm feeling an absolute idiot.
Struggling with this issue for days and can't find a suitable answer.

Have this dataset which 'amount' value can be updated. Need to send all
records with 'amount > 0' to a webservice as a Datatable. (Ignorant as I
might be) I Dim a new DataView (rowfilter 'amount > 0') and copy this into a new datatable:
dv = New DataView(ds.Tables("Items"), _
"amount > 0", _
"barcode", _
DataViewRowState.CurrentRows)

Dim dt As New DataTable("Result")
dt = dv.Table.Copy
sendDS.Tables.Add(dt)

However, sending this datatable (dt) to a webservice will send the entire
source dataset (= huge)

What am I doing wrong ...
Is there a more suitable way of achieving this!?

Thanks in advance.

[Bin Song, MCP]

Hi, Sjaakie

You might try the following

sendDS = ds.Clone(
Dim copyRows() As DataRow = ds.Tables("Items").Select("amount > 0"
Dim dt As DataTable = sendDS.Tables("Items"
Dim copyRow As DataRo
For Each copyRow In copyRow
dt.ImportRow(copyRow
Nex

Hope this will help

Bin Song , MC

----- Sjaakie Helderhorst wrote: ----

Hi

I've come a stage that I'm feeling an absolute idiot
Struggling with this issue for days and can't find a suitable answer

Have this dataset which 'amount' value can be updated. Need to send al
records with 'amount > 0' to a webservice as a Datatable. (Ignorant as
might be) I Dim a new DataView (rowfilter 'amount > 0') and copy this into
new datatable
dv = New DataView(ds.Tables("Items"),
"amount > 0",
"barcode",
DataViewRowState.CurrentRows

Dim dt As New DataTable("Result"
dt = dv.Table.Cop
sendDS.Tables.Add(dt

However, sending this datatable (dt) to a webservice will send the entir
source dataset (= huge

What am I doing wrong ..
Is there a more suitable way of achieving this!

Thanks in advance

[Sjaakie Helderhorst]

That did the trick, thanks!

"Bin Song, MCP" <an*******@discussions.microsoft.com> schreef in bericht
news:CF**********************************@microsof t.com...

Hi, Sjaakie,

You might try the following:

sendDS = ds.Clone()
Dim copyRows() As DataRow = ds.Tables("Items").Select("amount > 0")
Dim dt As DataTable = sendDS.Tables("Items")
Dim copyRow As DataRow
For Each copyRow In copyRows
dt.ImportRow(copyRow)
Next

Hope this will help,

Bin Song , MCP

----- Sjaakie Helderhorst wrote: -----

Hi,

I've come a stage that I'm feeling an absolute idiot.
Struggling with this issue for days and can't find a suitable answer.

Have this dataset which 'amount' value can be updated. Need to send all records with 'amount > 0' to a webservice as a Datatable. (Ignorant as I might be) I Dim a new DataView (rowfilter 'amount > 0') and copy this into a new datatable:
dv = New DataView(ds.Tables("Items"), _
"amount > 0", _
"barcode", _
DataViewRowState.CurrentRows)

Dim dt As New DataTable("Result")
dt = dv.Table.Copy
sendDS.Tables.Add(dt)

However, sending this datatable (dt) to a webservice will send the entire source dataset (= huge)

What am I doing wrong ...
Is there a more suitable way of achieving this!?

Thanks in advance.