Getting Data In The Same Record

I am trying to get these three different stored procedures to execute and enter data into the same record. It works, but each sql statement creates a new record, so account info, fromterritory info and toterritory info are in their own rows. Can anyone help me figure this out??





[Code]


Sub InsertData()








dim sql1 = "insertaccounttransfermike '" & AccNumber.SelectedItem.Value & "'"


dim sql2 = "insertaccounttransfermikefrom '" & FromName.SelectedItem.Value & "'"


dim sql3 = "insertaccounttransfermiketo '" & ToName.SelectedItem.Value & "'"





' Create Connection Object, Command Object, Connect to the database


Dim conn as New SQLConnection(connstr)





Dim cmd1 as New SQLCommand(sql1,conn)


Dim cmd2 as New SQLCommand(sql2,conn)


Dim cmd3 as New SQLCommand(sql3,conn)





conn.open()


cmd1.ExecuteNonQuery()


cmd2.ExecuteNonQuery()


cmd3.ExecuteNonQuery()


conn.Close()





' go to the datagrid query page


Response.redirect(return_page)








[/Code]