At the bottom is my code and I want to save data on my joined table. Please advise or edit the codes. Thanks :D
'VB.net
Public Class RadTechLP
Private Sub RadTechLP_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'PNJKDataSet.Procedure1' table. You can move, or remove it, as needed.
Me.Procedure1TableAdapter.Fill(Me.PNJKDataSet.Procedure1)
End Sub
End Class
'SQL Server
CREATE PROCEDURE [dbo].[Procedure1]
AS
SELECT table1.ID, table1.Name, table1.LastName, Table_1.ID,table_1.Gender
FROM Table1
JOIN Table_1
ON Table1.ID = Table_1.ID
RETURN 0