vb如何合并2个数据视图vb.net

Question

我想合并两个数据视图，第一个视图和Code、Name、credit、0 on debit，第二个视图代码，名称，0贷方，借方。我想把第一行和第二行合并，得到一个有1行的数据视图：代码、名称、贷方、借方

Sub Facture_old_Getdata((

Dim sRs, sRs1 As String
sRs = " select CodeClt,client , Sum(MontantTTc) As Credit , Cast('' As Double ) As Debit " _
& "from LV_Fact_CLient " _
& "where 1=1 and Codeclt ='" & TxtCodeClient.Text & "'" _
& "group by Codeclt,Client"

Rsdata = New DataView
Rsdata = c_DataSql.fGet_Data_ViewAccess(sRs)

sRs1 = "select Codeclt,Client , Cast('' As Double) As Credit , SUM(Montant) As Debit " _
& " from Gestionreg " _
& "where 1=1 and Codeclt ='" & TxtCodeClient.Text & "'" _
& "group by Codeclt,Client"
Rsdata1 = New DataView
Rsdata1 = c_DataSql.fGet_Data_ViewAccess(sRs1)

Rsdata1.Table.Merge(Rsdata.Table, False, MissingSchemaAction.Ignore)
End Sub

Answer 1

我认为你的问题与其说是与vb.net有关，不如说是与SQL有关。在这种情况下，UNION是您的朋友。您可以在此处找到更多信息：https://learn.microsoft.com/de-de/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-服务器-ver15