entlib UpdateDataSet how to update the database?

[Eduardo Silva]

Hi every body i new in dot.net and i am tring to update a table with a data
set using entlib i found the way to doit one by one but is any way to doit
in one command?

Code Sample

Dim dbCatalyst As Microsoft.Pract ices.Enterprise Library.Data.Da tabase =
DatabaseFactory .CreateDatabase ("CATALYST")

Dim sqlCatalyst As String = Me.sqlRecipient

Dim dbCatalystComma nd As DbCommand =
dbCatalyst.GetS qlStringCommand (sqlCatalyst)

Dim CatalystDataSet As DataSet =
dbCatalyst.Exec uteDataSet(dbCa talystCommand)

Dim CatalystTable As DataTable = CatalystDataSet .Tables(0)

'iseb

Dim dbISEB As Microsoft.Pract ices.Enterprise Library.Data.Da tabase =
DatabaseFactory .CreateDatabase ("ISEB")

Dim sqlISEB As String = "select * from tmpReportViewer "

Dim tmpReportViewer DataSet As New DataSet

Dim dbISEBCommand As DbCommand = dbISEB.GetSqlSt ringCommand(sql ISEB)

Dim tmpReportViewer Table As String = "tmpReportViewe r"

dbISEB.LoadData Set(dbISEBComma nd, tmpReportViewer DataSet,
tmpReportViewer Table)

Dim table As DataTable = tmpReportViewer DataSet.Tables( tmpReportViewer Table)

table = CatalystTable

Dim rowsAffected As Integer = dbISEB.UpdateDa taSet(tmpReport ViewerDataSet,
tmpReportViewer Table, Nothing, Nothing, Nothing, UpdateBehavior. Standard)

[PGC]

Eduardo,

Your last line (dbISEB.UpdateD ataSet) has no DBCommand objects to do this.
They are set to Nothing, Nothing, Nothing. Normally you would use three
stored procedures (SQL), an insert, an update and a delete procedure.

e.g.
cmdInsert = dbISEB.GetStore dProcCommand("s p_myInsert")
''' Add your sproc parameters here! - see AddInParameter method
cmdUpdate = dbISEB.GetStore dProcCommand("s p_myUpdate")
''' Add your sproc parameters here!
cmdDelete = dbISEB.GetStore dProcCommand("s p_myDelete")
''' Add your sproc parameters here!

You would then replace the Nothing, Nothing, Nothing with cmdInsert,
cmdUpdate, cmdDelete. Note: If all you are doing is performing one type of
action (e.g. Insert) then you can set the others to Nothing.

BTW microsoft.publi c.vsnet.enterpr ise.tools would probably be a better
newsgroup to post EntLib queries.

Paul

"Eduardo Silva" <ed*****@eduard o.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

Hi every body i new in dot.net and i am tring to update a table with a
data set using entlib i found the way to doit one by one but is any way to
doit in one command?

Code Sample

Dim dbCatalyst As Microsoft.Pract ices.Enterprise Library.Data.Da tabase =
DatabaseFactory .CreateDatabase ("CATALYST")

Dim sqlCatalyst As String = Me.sqlRecipient

Dim dbCatalystComma nd As DbCommand =
dbCatalyst.GetS qlStringCommand (sqlCatalyst)

Dim CatalystDataSet As DataSet =
dbCatalyst.Exec uteDataSet(dbCa talystCommand)

Dim CatalystTable As DataTable = CatalystDataSet .Tables(0)

'iseb

Dim dbISEB As Microsoft.Pract ices.Enterprise Library.Data.Da tabase =
DatabaseFactory .CreateDatabase ("ISEB")

Dim sqlISEB As String = "select * from tmpReportViewer "

Dim tmpReportViewer DataSet As New DataSet

Dim dbISEBCommand As DbCommand = dbISEB.GetSqlSt ringCommand(sql ISEB)

Dim tmpReportViewer Table As String = "tmpReportViewe r"

dbISEB.LoadData Set(dbISEBComma nd, tmpReportViewer DataSet,
tmpReportViewer Table)

Dim table As DataTable =
tmpReportViewer DataSet.Tables( tmpReportViewer Table)

table = CatalystTable

Dim rowsAffected As Integer = dbISEB.UpdateDa taSet(tmpReport ViewerDataSet,
tmpReportViewer Table, Nothing, Nothing, Nothing, UpdateBehavior. Standard)