some thing like this..i've tried...
--------------------------------------------
Public Class SQl_insert
Public Function insert(ByVal userid As Int32, ByVal username As String, ByVal password As String, ByVal user As String, ByVal firstname As String, ByVal lastname As String, ByVal phone As Int32, ByVal street As String, ByVal city As String, ByVal state As String, ByVal zip As Int32, ByVal country As String, ByVal Othercont As String)
Dim sqlConn As SqlConnection
Dim sqlCmd As SqlCommand
Dim sqlCmd2 As SqlCommand
Dim res As String
sqlConn = New SqlConnection("server=localhost;uid=sa; pwd=;database=Databases;")
sqlConn.Open()
sqlCmd = New SqlCommand("Insert User_login_info values('username','password','User')", sqlConn)
sqlCmd2 = New SqlCommand("Insert User_detail_info values('firstname','lastname',phone,'street','city ','state',zip,'country','Othercont')", sqlConn)
sqlCmd.ExecuteNonQuery()
sqlCmd2.ExecuteNonQuery()
sqlConn.Close()
End Function
End Class
'In aspx page..
'Dim insrt As SQl_insert
' insrt.insert(userid,tbox3,tbox4,tbox1,tbox2,tbox5, tbox6,tbox7,tbox8,tbox9,tbox10,tbox11,radiobutton1 )
-------------------------------------------
|