Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Update database table from SQL Union
I have trying without success to update a database table from my VB code which is creating a UNION statement. Could someone help me?
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'--------------- FILL FROM Employess & New Employees Tables
'**------- FILL BY UNION
Dim conn As New SqlConnection("Server=(Local);" & _
"DataBase=Northwind; Integrated Security=SSPI")
Dim sqlstr As String = "SELECT * FROM Employees UNION Select * _ from NewEmployees"
da = New SqlDataAdapter(sqlstr, conn)
da.AcceptChangesDuringFill = False
da.Fill(ds, "Employees") ' The Fill method maps the result set _ a DATATABLE object in the given DATASET
' Display the results
DataGridView1.DataSource = ds.Tables("Employees") ' Fill the _ datagridview with with the Table
' Code to Update by to the original database.
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Dim cb As New SqlCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand()
da.DeleteCommand = cb.GetDeleteCommand()
da.UpdateCommand = cb.GetUpdateCommand()
If ds.HasChanges Then da.Update(ds.Tables("Employees"))
Catch ex As Exception
MessageBox.Show("Database Error or No Updates To Processed")
I would be happy to either save the results of the UNION datatable back to either of the original tables (Employees or New Employees) or back to a new table called "AllEmployees"
My goal is just to merge the the two SQL database tables.