table1=> id int, name
table2=>id int references table1 ,address
I have a form from which data must must go into these 2 tables.
now in my inesrt query in asp.net code behind how do i enter data in both tables
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO table1(id,name) VALUES (@TextValue,@TextValue1)";
now where do i do INSERT INTO TABLE2??
...
Go to the complete details ...