Member Avatar for Japhet_1

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
  • 2 Contributors
  • 1 Reply
  • 194 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by tdrosiadis
Member Avatar for tdrosiadis

If I have understand corectlly what you need, it seems that you want to be able to update the the result of the join. There are some joins that are not updatable by default. In such a case consider using a parent-child form aproach whitch is updatable in all cases.
Tasos Drosiadis

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.