Transferring data between datatables and between datareader and datatable

[neilr]

Can anyone help with some problkems that have wasted 2 days of my
(inexperienced) time already?

We have a website which allows people to register for events like
conferences

We are importing a table of fees for the apporpriate event using an Sp:
FeesDataSet = New System.Data.Dat aSet
Dim MySPcommand As New System.Data.Sql Client.SqlComma nd
MySPcommand.Com mandText = "SP4105201getWe bFeeTable"
MySPcommand.Com mandType = Data.CommandTyp e.StoredProcedu re
MySPcommand.Con nection =
GlobalLeague.Ut ilities.Functio ns.GetConnectio n(True)
MySPcommand.Par ameters.AddWith Value("@Project No",
const_WarsawPro jectNo)
Me.FeesDataSet. Tables.Add("Fee s")
Me.FeesDataSet. Tables(0).Load( MySPcommand.Exe cuteReader())
MySPcommand.Con nection.Close()
MySPcommand = Nothing

So far, so good. We then need to add a couple of "discretion ary fees"
if the customer selects the approriate boxes on the page. We get a
single row of data (same format but different SP) and ideally need to
add that row to the "Fees" table. I can get it into another table (same
method as above) or into a datareader, but cannot find exactly how to
add it as a row into the "Fees" table from either the new table or from
a datareader?

A little later, we use the controls on the web page to pick up the
customer's options and I am storing these by changing the (existing)
"Pick" field in the "Fees" table to 1 for the appropriate rows (ie
fees). I can then get use:
FeesDataSet.Tab les("Fees").Sel ect("Pick = 1")
to get a set of rows which we need to charge to this customer. Ideally
I want to move these to another table ("Charges") in the same dataset,
so that we can perform various calculations and text changes on them
before printing them to his invoice. I have tried cloning the table to
set the schema for the "Charges" table to match the "Fees" table and
then import the rows, but I cannot seem to get the code right.

Can anyone help me with these 2 tasks - ie getting a row from a table
or datareader and copying it into the "Fees" table, asnd then taking a
set of selected rows from the "Fees" table and using them to create the
"Charges" table?

[Cor Ligthert [MVP]]

Neil,

That was very much reading and trying to understand.

Probably are you just looking for the command importrow

http://msdn2.microsoft.com/en-us/lib...importrow.aspx

You cannot add a datarow to two tables, simple for the fact that the datarow
has a property which tells to what datatable it belongs

I hope this helps,

Cor

"neilr" <ne*******@yaho o.comschreef in bericht
news:11******** *************@m 79g2000cwm.goog legroups.com...

Can anyone help with some problkems that have wasted 2 days of my
(inexperienced) time already?

We have a website which allows people to register for events like
conferences

We are importing a table of fees for the apporpriate event using an Sp:
FeesDataSet = New System.Data.Dat aSet
Dim MySPcommand As New System.Data.Sql Client.SqlComma nd
MySPcommand.Com mandText = "SP4105201getWe bFeeTable"
MySPcommand.Com mandType = Data.CommandTyp e.StoredProcedu re
MySPcommand.Con nection =
GlobalLeague.Ut ilities.Functio ns.GetConnectio n(True)
MySPcommand.Par ameters.AddWith Value("@Project No",
const_WarsawPro jectNo)
Me.FeesDataSet. Tables.Add("Fee s")
Me.FeesDataSet. Tables(0).Load( MySPcommand.Exe cuteReader())
MySPcommand.Con nection.Close()
MySPcommand = Nothing

So far, so good. We then need to add a couple of "discretion ary fees"
if the customer selects the approriate boxes on the page. We get a
single row of data (same format but different SP) and ideally need to
add that row to the "Fees" table. I can get it into another table (same
method as above) or into a datareader, but cannot find exactly how to
add it as a row into the "Fees" table from either the new table or from
a datareader?

A little later, we use the controls on the web page to pick up the
customer's options and I am storing these by changing the (existing)
"Pick" field in the "Fees" table to 1 for the appropriate rows (ie
fees). I can then get use:
FeesDataSet.Tab les("Fees").Sel ect("Pick = 1")
to get a set of rows which we need to charge to this customer. Ideally
I want to move these to another table ("Charges") in the same dataset,
so that we can perform various calculations and text changes on them
before printing them to his invoice. I have tried cloning the table to
set the schema for the "Charges" table to match the "Fees" table and
then import the rows, but I cannot seem to get the code right.

Can anyone help me with these 2 tasks - ie getting a row from a table
or datareader and copying it into the "Fees" table, asnd then taking a
set of selected rows from the "Fees" table and using them to create the
"Charges" table?

[neilr]

Cor,
That got me started, thank you - I had tried that before but must have
got the code wrong. It now works, as follows if anyone else needs help:
Dim ChargesTable As Data.DataTable
ChargesTable = Me.FeesDataSet. Tables("Fees"). Clone
ChargesTable.Ta bleName = "Charges"
For Each ChargesRow In FeesDataSet.Tab les("Fees").Sel ect("Pick
= 1")
ChargesTable.Im portRow(Charges Row)
Next
If Not Me.FeesDataSet. Tables("Charges ") Is Nothing Then
Me.FeesDataSet. Tables.Remove(" Charges")
End If
Me.FeesDataSet. Tables.Add(Char gesTable)

By the way, my note was long because I had read so many where novices
like me were criticised for not including their code and explaining the
problem!

Thanks again, Neil

Cor Ligthert [MVP] wrote:

Neil,

That was very much reading and trying to understand.

Probably are you just looking for the command importrow

http://msdn2.microsoft.com/en-us/lib...importrow.aspx

You cannot add a datarow to two tables, simple for the fact that the datarow
has a property which tells to what datatable it belongs

I hope this helps,

Cor

"neilr" <ne*******@yaho o.comschreef in bericht
news:11******** *************@m 79g2000cwm.goog legroups.com...

Can anyone help with some problkems that have wasted 2 days of my
(inexperienced) time already?

We have a website which allows people to register for events like
conferences

We are importing a table of fees for the apporpriate event using an Sp:
FeesDataSet = New System.Data.Dat aSet
Dim MySPcommand As New System.Data.Sql Client.SqlComma nd
MySPcommand.Com mandText = "SP4105201getWe bFeeTable"
MySPcommand.Com mandType = Data.CommandTyp e.StoredProcedu re
MySPcommand.Con nection =
GlobalLeague.Ut ilities.Functio ns.GetConnectio n(True)
MySPcommand.Par ameters.AddWith Value("@Project No",
const_WarsawPro jectNo)
Me.FeesDataSet. Tables.Add("Fee s")
Me.FeesDataSet. Tables(0).Load( MySPcommand.Exe cuteReader())
MySPcommand.Con nection.Close()
MySPcommand = Nothing

So far, so good. We then need to add a couple of "discretion ary fees"
if the customer selects the approriate boxes on the page. We get a
single row of data (same format but different SP) and ideally need to
add that row to the "Fees" table. I can get it into another table (same
method as above) or into a datareader, but cannot find exactly how to
add it as a row into the "Fees" table from either the new table or from
a datareader?

A little later, we use the controls on the web page to pick up the
customer's options and I am storing these by changing the (existing)
"Pick" field in the "Fees" table to 1 for the appropriate rows (ie
fees). I can then get use:
FeesDataSet.Tab les("Fees").Sel ect("Pick = 1")
to get a set of rows which we need to charge to this customer. Ideally
I want to move these to another table ("Charges") in the same dataset,
so that we can perform various calculations and text changes on them
before printing them to his invoice. I have tried cloning the table to
set the schema for the "Charges" table to match the "Fees" table and
then import the rows, but I cannot seem to get the code right.

Can anyone help me with these 2 tasks - ie getting a row from a table
or datareader and copying it into the "Fees" table, asnd then taking a
set of selected rows from the "Fees" table and using them to create the
"Charges" table?