Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating to a database after merging?

Status
Not open for further replies.
jwarmuth

jwarmuth

IS-IT--Management
Joined
Sep 22, 2001
Messages
151
Location
CA
I've merged data from my untyped dataset into my typed dataset.

I've confirmed the typed dataset does contain the new data, however when I call the sqladapter.update(dataset) method, nothing is uploaded to the database.

When I query the status of the dataset it does confirm changes.

Why would it not send the databack? I'm I missing something?


Here's the code..

Code: 
                Ds_stocksDaily1.Merge(ds_stockRecord, True, MissingSchemaAction.Add)
            SqlDataAdapter1.Update(Ds_stocksDaily1)

Jeff W.
MCSE, CNE
 
Sort by date Sort by votes
Did you set the UpdateCommand, InsertCommand and DeleteCommand of the DataAdapter?
 
Upvote 0 Downvote
This time I used the wizard to create the dataadapter and then the dataset.

Jeff W.
MCSE, CNE
 
Upvote 0 Downvote
So yes.

I verify the auto generated code for myself. Tis all there.

Jeff W.
MCSE, CNE
 
Upvote 0 Downvote
Absolutely. :) Which parts would you like?

Here's teh autogenerated code for the dataadapter and dataset

Code: 
'SqlDataAdapter1
        '
        Me.SqlDataAdapter1.DeleteCommand = Me.SqlDeleteCommand1
        Me.SqlDataAdapter1.InsertCommand = Me.SqlInsertCommand1
        Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1
        Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "StocksDaily", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("stkD_ID", "stkD_ID"), New System.Data.Common.DataColumnMapping("stkD_symbol", "stkD_symbol"), New System.Data.Common.DataColumnMapping("stkD_last", "stkD_last"), New System.Data.Common.DataColumnMapping("stkD_date", "stkD_date"), New System.Data.Common.DataColumnMapping("stkD_time", "stkD_time"), New System.Data.Common.DataColumnMapping("stkD_change", "stkD_change"), New System.Data.Common.DataColumnMapping("stkD_open", "stkD_open"), New System.Data.Common.DataColumnMapping("stkD_high", "stkD_high"), New System.Data.Common.DataColumnMapping("stkD_low", "stkD_low"), New System.Data.Common.DataColumnMapping("stkD_volume", "stkD_volume"), New System.Data.Common.DataColumnMapping("stkD_mktCap", "stkD_mktCap"), New System.Data.Common.DataColumnMapping("stkD_previousClose", "stkD_previousClose"), New System.Data.Common.DataColumnMapping("stkD_percentageChange", "stkD_percentageChange"), New System.Data.Common.DataColumnMapping("stkD_annRangeUpper", "stkD_annRangeUpper"), New System.Data.Common.DataColumnMapping("stkD_annRangeLower", "stkD_annRangeLower"), New System.Data.Common.DataColumnMapping("stkD_earns", "stkD_earns"), New System.Data.Common.DataColumnMapping("stkD_pe", "stkD_pe"), New System.Data.Common.DataColumnMapping("stkD_name", "stkD_name")})})
        Me.SqlDataAdapter1.UpdateCommand = Me.SqlUpdateCommand1
        '
        'SqlSelectCommand1
        '
        Me.SqlSelectCommand1.CommandText = "SELECT stkD_ID, stkD_symbol, stkD_last, stkD_date, stkD_time, stkD_change, stkD_o" & _
        "pen, stkD_high, stkD_low, stkD_volume, stkD_mktCap, stkD_previousClose, stkD_per" & _
        "centageChange, stkD_annRangeUpper, stkD_annRangeLower, stkD_earns, stkD_pe, stkD" & _
        "_name FROM StocksDaily"
        Me.SqlSelectCommand1.Connection = Me.SqlConnection1
        '
        'SqlInsertCommand1
        '
        Me.SqlInsertCommand1.CommandText = "INSERT INTO StocksDaily(stkD_symbol, stkD_last, stkD_date, stkD_time, stkD_change" & _
        ", stkD_open, stkD_high, stkD_low, stkD_volume, stkD_mktCap, stkD_previousClose, " & _
        "stkD_percentageChange, stkD_annRangeUpper, stkD_annRangeLower, stkD_earns, stkD_" & _
        "pe, stkD_name) VALUES (@stkD_symbol, @stkD_last, @stkD_date, @stkD_time, @stkD_c" & _
        "hange, @stkD_open, @stkD_high, @stkD_low, @stkD_volume, @stkD_mktCap, @stkD_prev" & _
        "iousClose, @stkD_percentageChange, @stkD_annRangeUpper, @stkD_annRangeLower, @st" & _
        "kD_earns, @stkD_pe, @stkD_name); SELECT stkD_ID, stkD_symbol, stkD_last, stkD_da" & _
        "te, stkD_time, stkD_change, stkD_open, stkD_high, stkD_low, stkD_volume, stkD_mk" & _
        "tCap, stkD_previousClose, stkD_percentageChange, stkD_annRangeUpper, stkD_annRan" & _
        "geLower, stkD_earns, stkD_pe, stkD_name FROM StocksDaily WHERE (stkD_ID = @@IDEN" & _
        "TITY)"
        Me.SqlInsertCommand1.Connection = Me.SqlConnection1
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_symbol", System.Data.SqlDbType.VarChar, 10, "stkD_symbol"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_last", System.Data.SqlDbType.Money, 4, "stkD_last"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_date", System.Data.SqlDbType.DateTime, 8, "stkD_date"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_time", System.Data.SqlDbType.DateTime, 8, "stkD_time"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_change", System.Data.SqlDbType.Money, 4, "stkD_change"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_open", System.Data.SqlDbType.Money, 4, "stkD_open"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_high", System.Data.SqlDbType.Money, 4, "stkD_high"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_low", System.Data.SqlDbType.Money, 4, "stkD_low"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_volume", System.Data.SqlDbType.Int, 4, "stkD_volume"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_mktCap", System.Data.SqlDbType.Int, 4, "stkD_mktCap"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_previousClose", System.Data.SqlDbType.Money, 4, "stkD_previousClose"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_percentageChange", System.Data.SqlDbType.Money, 4, "stkD_percentageChange"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_annRangeUpper", System.Data.SqlDbType.Money, 4, "stkD_annRangeUpper"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_annRangeLower", System.Data.SqlDbType.Money, 4, "stkD_annRangeLower"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_earns", System.Data.SqlDbType.Money, 4, "stkD_earns"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_pe", System.Data.SqlDbType.Money, 4, "stkD_pe"))
        Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_name", System.Data.SqlDbType.VarChar, 10, "stkD_name"))
        '
        'SqlUpdateCommand1
        '
        Me.SqlUpdateCommand1.CommandText = "UPDATE StocksDaily SET stkD_symbol = @stkD_symbol, stkD_last = @stkD_last, stkD_d" & _
        "ate = @stkD_date, stkD_time = @stkD_time, stkD_change = @stkD_change, stkD_open " & _
        "= @stkD_open, stkD_high = @stkD_high, stkD_low = @stkD_low, stkD_volume = @stkD_" & _
        "volume, stkD_mktCap = @stkD_mktCap, stkD_previousClose = @stkD_previousClose, st" & _
        "kD_percentageChange = @stkD_percentageChange, stkD_annRangeUpper = @stkD_annRang" & _
        "eUpper, stkD_annRangeLower = @stkD_annRangeLower, stkD_earns = @stkD_earns, stkD" & _
        "_pe = @stkD_pe, stkD_name = @stkD_name WHERE (stkD_ID = @Original_stkD_ID) AND (" & _
        "stkD_annRangeLower = @Original_stkD_annRangeLower OR @Original_stkD_annRangeLowe" & _
        "r IS NULL AND stkD_annRangeLower IS NULL) AND (stkD_annRangeUpper = @Original_st" & _
        "kD_annRangeUpper OR @Original_stkD_annRangeUpper IS NULL AND stkD_annRangeUpper " & _
        "IS NULL) AND (stkD_change = @Original_stkD_change OR @Original_stkD_change IS NU" & _
        "LL AND stkD_change IS NULL) AND (stkD_date = @Original_stkD_date OR @Original_st" & _
        "kD_date IS NULL AND stkD_date IS NULL) AND (stkD_earns = @Original_stkD_earns OR" & _
        " @Original_stkD_earns IS NULL AND stkD_earns IS NULL) AND (stkD_high = @Original" & _
        "_stkD_high OR @Original_stkD_high IS NULL AND stkD_high IS NULL) AND (stkD_last " & _
        "= @Original_stkD_last OR @Original_stkD_last IS NULL AND stkD_last IS NULL) AND " & _
        "(stkD_low = @Original_stkD_low OR @Original_stkD_low IS NULL AND stkD_low IS NUL" & _
        "L) AND (stkD_mktCap = @Original_stkD_mktCap OR @Original_stkD_mktCap IS NULL AND" & _
        " stkD_mktCap IS NULL) AND (stkD_name = @Original_stkD_name OR @Original_stkD_nam" & _
        "e IS NULL AND stkD_name IS NULL) AND (stkD_open = @Original_stkD_open OR @Origin" & _
        "al_stkD_open IS NULL AND stkD_open IS NULL) AND (stkD_pe = @Original_stkD_pe OR " & _
        "@Original_stkD_pe IS NULL AND stkD_pe IS NULL) AND (stkD_percentageChange = @Ori" & _
        "ginal_stkD_percentageChange OR @Original_stkD_percentageChange IS NULL AND stkD_" & _
        "percentageChange IS NULL) AND (stkD_previousClose = @Original_stkD_previousClose" & _
        " OR @Original_stkD_previousClose IS NULL AND stkD_previousClose IS NULL) AND (st" & _
        "kD_symbol = @Original_stkD_symbol OR @Original_stkD_symbol IS NULL AND stkD_symb" & _
        "ol IS NULL) AND (stkD_time = @Original_stkD_time OR @Original_stkD_time IS NULL " & _
        "AND stkD_time IS NULL) AND (stkD_volume = @Original_stkD_volume OR @Original_stk" & _
        "D_volume IS NULL AND stkD_volume IS NULL); SELECT stkD_ID, stkD_symbol, stkD_las" & _
        "t, stkD_date, stkD_time, stkD_change, stkD_open, stkD_high, stkD_low, stkD_volum" & _
        "e, stkD_mktCap, stkD_previousClose, stkD_percentageChange, stkD_annRangeUpper, s" & _
        "tkD_annRangeLower, stkD_earns, stkD_pe, stkD_name FROM StocksDaily WHERE (stkD_I" & _
        "D = @stkD_ID)"
        Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_symbol", System.Data.SqlDbType.VarChar, 10, "stkD_symbol"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_last", System.Data.SqlDbType.Money, 4, "stkD_last"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_date", System.Data.SqlDbType.DateTime, 8, "stkD_date"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_time", System.Data.SqlDbType.DateTime, 8, "stkD_time"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_change", System.Data.SqlDbType.Money, 4, "stkD_change"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_open", System.Data.SqlDbType.Money, 4, "stkD_open"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_high", System.Data.SqlDbType.Money, 4, "stkD_high"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_low", System.Data.SqlDbType.Money, 4, "stkD_low"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_volume", System.Data.SqlDbType.Int, 4, "stkD_volume"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_mktCap", System.Data.SqlDbType.Int, 4, "stkD_mktCap"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_previousClose", System.Data.SqlDbType.Money, 4, "stkD_previousClose"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_percentageChange", System.Data.SqlDbType.Money, 4, "stkD_percentageChange"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_annRangeUpper", System.Data.SqlDbType.Money, 4, "stkD_annRangeUpper"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_annRangeLower", System.Data.SqlDbType.Money, 4, "stkD_annRangeLower"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_earns", System.Data.SqlDbType.Money, 4, "stkD_earns"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_pe", System.Data.SqlDbType.Money, 4, "stkD_pe"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_name", System.Data.SqlDbType.VarChar, 10, "stkD_name"))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_ID", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_annRangeLower", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_annRangeLower", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_annRangeUpper", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_annRangeUpper", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_change", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_change", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_date", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_earns", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_earns", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_high", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_high", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_last", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_last", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_low", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_low", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_mktCap", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_mktCap", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_name", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_name", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_open", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_open", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_pe", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_pe", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_percentageChange", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_percentageChange", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_previousClose", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_previousClose", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_symbol", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_symbol", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_time", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_time", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_volume", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_volume", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@stkD_ID", System.Data.SqlDbType.Int, 4, "stkD_ID"))
        '
        'SqlDeleteCommand1
        '
        Me.SqlDeleteCommand1.CommandText = "DELETE FROM StocksDaily WHERE (stkD_ID = @Original_stkD_ID) AND (stkD_annRangeLow" & _
        "er = @Original_stkD_annRangeLower OR @Original_stkD_annRangeLower IS NULL AND st" & _
        "kD_annRangeLower IS NULL) AND (stkD_annRangeUpper = @Original_stkD_annRangeUpper" & _
        " OR @Original_stkD_annRangeUpper IS NULL AND stkD_annRangeUpper IS NULL) AND (st" & _
        "kD_change = @Original_stkD_change OR @Original_stkD_change IS NULL AND stkD_chan" & _
        "ge IS NULL) AND (stkD_date = @Original_stkD_date OR @Original_stkD_date IS NULL " & _
        "AND stkD_date IS NULL) AND (stkD_earns = @Original_stkD_earns OR @Original_stkD_" & _
        "earns IS NULL AND stkD_earns IS NULL) AND (stkD_high = @Original_stkD_high OR @O" & _
        "riginal_stkD_high IS NULL AND stkD_high IS NULL) AND (stkD_last = @Original_stkD" & _
        "_last OR @Original_stkD_last IS NULL AND stkD_last IS NULL) AND (stkD_low = @Ori" & _
        "ginal_stkD_low OR @Original_stkD_low IS NULL AND stkD_low IS NULL) AND (stkD_mkt" & _
        "Cap = @Original_stkD_mktCap OR @Original_stkD_mktCap IS NULL AND stkD_mktCap IS " & _
        "NULL) AND (stkD_name = @Original_stkD_name OR @Original_stkD_name IS NULL AND st" & _
        "kD_name IS NULL) AND (stkD_open = @Original_stkD_open OR @Original_stkD_open IS " & _
        "NULL AND stkD_open IS NULL) AND (stkD_pe = @Original_stkD_pe OR @Original_stkD_p" & _
        "e IS NULL AND stkD_pe IS NULL) AND (stkD_percentageChange = @Original_stkD_perce" & _
        "ntageChange OR @Original_stkD_percentageChange IS NULL AND stkD_percentageChange" & _
        " IS NULL) AND (stkD_previousClose = @Original_stkD_previousClose OR @Original_st" & _
        "kD_previousClose IS NULL AND stkD_previousClose IS NULL) AND (stkD_symbol = @Ori" & _
        "ginal_stkD_symbol OR @Original_stkD_symbol IS NULL AND stkD_symbol IS NULL) AND " & _
        "(stkD_time = @Original_stkD_time OR @Original_stkD_time IS NULL AND stkD_time IS" & _
        " NULL) AND (stkD_volume = @Original_stkD_volume OR @Original_stkD_volume IS NULL" & _
        " AND stkD_volume IS NULL)"
        Me.SqlDeleteCommand1.Connection = Me.SqlConnection1
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_ID", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_annRangeLower", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_annRangeLower", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_annRangeUpper", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_annRangeUpper", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_change", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_change", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_date", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_earns", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_earns", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_high", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_high", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_last", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_last", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_low", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_low", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_mktCap", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_mktCap", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_name", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_name", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_open", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_open", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_pe", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_pe", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_percentageChange", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_percentageChange", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_previousClose", System.Data.SqlDbType.Money, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_previousClose", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_symbol", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_symbol", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_time", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_time", System.Data.DataRowVersion.Original, Nothing))
        Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_stkD_volume", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "stkD_volume", System.Data.DataRowVersion.Original, Nothing))
        '
        'SqlConnection1
        '
        Me.SqlConnection1.ConnectionString = "workstation id=STIMPY;packet size=4096;integrated security=SSPI;data source=STIMP" & _
        "Y;persist security info=False;initial catalog=Phaeton"
        '
        'Ds_stocksDaily1
        '
        Me.Ds_stocksDaily1.DataSetName = "ds_stocksDaily"
        Me.Ds_stocksDaily1.Locale = New System.Globalization.CultureInfo("en-US")


And here's the code used to create the user created dataset. Please note the name of the dataset in this code is not mentioned outside of the scope as it is inside formatXMLToDataset function that returns the ds_formattedXML dataset.

Code: 
'create the dataset and table
                Dim ds_formattedXML As DataSet = New DataSet
                Dim dt_formattedXML As DataTable = New DataTable("stockQuote")
                ds_formattedXML.Tables.Add(dt_formattedXML)

                'define table column types
                dt_formattedXML.Columns.Add("symbol", Type.GetType("System.String"))
                dt_formattedXML.Columns.Add("last", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("date", Type.GetType("System.DateTime"))
                dt_formattedXML.Columns.Add("time", Type.GetType("System.DateTime"))
                dt_formattedXML.Columns.Add("change", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("open", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("high", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("low", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("volume", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("mktcap", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("previousClose", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("percentageChange", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("annRangeUpper", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("annRangeLower", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("earns", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("pe", Type.GetType("System.Decimal"))
                dt_formattedXML.Columns.Add("name", Type.GetType("System.String"))

                'create the datarow
                Dim dr_formattedXML As DataRow = dt_formattedXML.NewRow()

                'Fill the datarow with values and add it to the table
                dr_formattedXML("symbol") = symbolValue
                dr_formattedXML("last") = lastValue
                dr_formattedXML("date") = dateValue
                dr_formattedXML("time") = timeValue
                dr_formattedXML("change") = changeValue
                dr_formattedXML("open") = openValue
                dr_formattedXML("high") = highValue
                dr_formattedXML("low") = lowValue
                dr_formattedXML("volume") = volumeValue
                dr_formattedXML("mktcap") = mktcapValue
                dr_formattedXML("previousClose") = previousCloseValue
                dr_formattedXML("percentageChange") = percentageChangeValue
                dr_formattedXML("annRangeUpper") = annRangeUpperValue
                dr_formattedXML("annRangeLower") = annRangeLowerValue
                dr_formattedXML("earns") = earnsValue
                dr_formattedXML("pe") = peValue
                dr_formattedXML("name") = nameValue

                dt_formattedXML.Rows.Add(dr_formattedXML)
return ds_formattedXML

That code creates the datasets. This is where I bring it all together.

Code: 
Dim ii As Integer
            For ii = 0 To sht_numberOfStocks - 1
                'create dataset for returned XML data for transfer
                Dim ds_stockRecord As DataSet

                quoteToXMLFile(arr_stocksList(ii))
                ds_stockRecord = formatXMLtoDataset(tempXMLFileLoc)

                'merge datasets

                Ds_stocksDaily1.Merge(ds_stockRecord, True, MissingSchemaAction.Add)

            Next ii


If I query the ds_stocksDaily1 dataset, it does return data, so I know it's merging successfully.

However when I call the update method, it doesn't send the data back to the db.

Jeff W.
MCSE, CNE
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question Question
graph with access database - im on vb6
Replies
10
Views
1K
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated
Replies
9
Views
2K
Andrzejek
Andrzejek
sal21
  • Question Question
printing picturebox to the default printer
Replies
2
Views
184
henry crown
henry crown
sal21
  • Question Question
delete ll picturebox in a form
Replies
8
Views
371
strongm
strongm
Swi
  • Locked
  • Question Question
Printer.Print to PDF
Replies
16
Views
2K
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top