How to insert two tables at the same time

roykent

There are 3 tables: categoryrogy (course), fields: categoryrogyid, categoryrogyname, categoryrogydescription, viewcount, datetime, ohter (address); department (department) table, fields: departmentid, departmentname, viewcount; category_in_depart table, fields:
departid, caterogyid, caterogyname, viewcount

Now it's time for administrators to add functionality:
<tr> <td style = "height: 68px"> Department name </ td>
<td style = "height: 68px">
    <asp: DropDownList ID = "DropDownList1" runat = "server" DataSourceID = "AccessDataSource1"
        DataTextField = "departname" DataValueField = "departid">
    </ asp: DropDownList>
    <asp: AccessDataSource ID = "AccessDataSource1" runat = "server" DataFile = "~ / App_Data / videoplay.mdb"
        SelectCommand = "SELECT [departid], [departname] FROM [depart]"> </ asp: AccessDataSource>
</ td>
</ tr>
<tr>
<td> course name </ td>
<td>
    <asp: TextBox ID = "TextBox2" runat = "server"> </ asp: TextBox> </ td> </ tr>
     <tr> <td> Course ID </ td>
<td>
    <asp: TextBox ID = "TextBox1" runat = "server"> </ asp: TextBox> </ td> </ tr>
    
    <tr> <td> Course description </ td>
<td>
    <asp: TextBox ID = "TextBox3" runat = "server" Height = "62px" Width = "168px"> </ asp: TextBox> </ td> </ tr>
    <tr> <td> address </ td>
<td>
    <asp: TextBox ID = "TextBox4" runat = "server"> </ asp: TextBox> </ td> </ tr>
   <tr> <td>
       <asp: Button ID = "Button1" runat = "server" Text = "post" OnClick = "Button1_Click" /> </ td>
       <td> <asp: Label runat = "server" ID = "result"> </ asp: Label> </ td> </ tr>
That is to say, to insert new records into two tables and write access statements?

我是杀人狂

trigger

roykent

Can you tell me more about LS? Thank you

我是杀人狂

create trigger on table1
for insert
as
if inseted (table1)
begin
insert into table2 values ​​...
end
After building the trigger, when table1 is inserted, table2 also inserts content

prajna

Insert the main table, get @@ identity, insert the related table

fanfan1980

access without trigger

我是杀人狂

--# Down, then I do n’t know ~

roykent

How shouldfanfan1980be written?
PS: You helped me solve the last problem
:)

roykent

That is to say, it needs to be inserted into two tables: category and department, but the third table, cate_in_depart, also needs to change accordingly, and how can the rest of the fields such as categoryid get values?

fanfan1980

Can't write two insert statements?