Hi there,
Are they related tables via an ID?
If so, u could have your submit button click event handle two sub routine
calls, each dealing with its own table. Of course the order of insertion
will depend on the relationship if any.
If they are related and you are using stored procedures and u need theat
first table's ID value you could use an output parameter on your first
stored procedure to send that nID back, then use that ID for the insert on
second table.
Public Sub btnSubmit_Click(ByVal Sender As Object, ByVal E As EventArgs)
Handles submitform.Click
InsertTableOne()
InsertTableTwo()
End Sub
An idea anyways, Joe :)
"NuB" <Nu*@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com...
I have a web form and when the user clicks update I have to update 2
seperate tables, How can I do that? Right now I'm using straightline SQL for this.