需要在vb，bet中的datarow中进行更新 [英] Need to do update in datarow in vb,bet

问题描述

需要保存更新drNewRow("FinancialContactID")= GetID("tblFinancialContactTest"，"FinancialContactID")-1
它是主键，但不是身份种子.我需要更新该行，注意主键是finanicalcontactid
我要保存ID.

Need to save update drNewRow("FinancialContactID") = GetID("tblFinancialContactTest", "FinancialContactID") - 1
It is a primary key but not identity seed. I need to updat the row note the primary key is finanicalcontactid
I want to save the id.

Try 
    ''Add Financial Contact record 
    adaptFinancialContact = New SqlClient.SqlDataAdapter("Select * From tblFinancialContactTest", conSQL) 
    datAddFinancialContact = New DataSet 
    adaptFinancialContact.FillSchema(datAddFinancialContact, SchemaType.Source, "FinancialContact") 
    adaptFinancialContact.MissingSchemaAction = MissingSchemaAction.AddWithKey 
    adaptFinancialContact.Fill(datAddFinancialContact, "FinancialContact") 
    Dim drNewRow As DataRow 
    drNewRow = datAddFinancialContact.Tables("FinancialContact").NewRow 
    ''drNewRow("FinancialContactID") = GetID("tblFinancialContactTest", "FinancialContactID") - 1 
    drNewRow("ProviderID") = intProvID 

    drNewRow("FinancialContactPrefix") = cboFinancialContactSalutation.Text 
    drNewRow("FinancialContact") = Trim(txtFinancialContactName.Text) 
    drNewRow("FinancialPosition") = Trim(txtFinancialContactPosition.Text) 
    drNewRow("FinancialPhone") = Trim(txtFinancialContactPhone.Text) 
    drNewRow("FinancialExtension") = Trim(txtFinancialPhoneExtension.Text) 
    drNewRow("FinancialFax") = Trim(txtFinancialFaxNumber.Text) 
    drNewRow("FinancialEmail") = Trim(txtFinancialEmail.Text) 
    datAddFinancialContact.Tables("FinancialContact").Rows.Add(drNewRow) 
    Dim sqlCommBuild As New SqlClient.SqlCommandBuilder(adaptFinancialContact) 
    adaptFinancialContact.Update(datAddFinancialContact, "FinancialContact") 
Catch ex As Exception 
    CentralExceptionHandler(ex, "Add financial contact") 
End Try.

推荐答案

它不存在，它将创建一个新行而不是更新右行.

it exist does not exist, it will create a new row instead of updating the right row.

这篇关于需要在vb，bet中的datarow中进行更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！