如何将数据插入相关表？ [英] How do I insert data into related tables ?

问题描述

Hello Everyone



我用C＃语言创建应用程序并将FormWin中的数据保存到相关表格的数据库中，例如：

Hello Everyone

I was create application with C# langage and saved the data from FormWin into a data base into related tables e.g:

create table table1
(
   id_table1 integer primary key,
   .
   .
   .
   id_table2 integer
);

id_table2是表table1中的外键

id_table2 is a foreign key in table table1

create table table2
(
   id_table2 integer primary key,
   .
   .
   .
);

i需要一个如何将数据插入表格？ br />
提前谢谢。

i need a astus how to insert data into tables ?
Thank you in advance.

推荐答案

基本链接：

http://www.msdotnet.co .in / 2012/06 / how-to-insert-data-in-database-and.html＃.U7voL_mSyrE [ ^ ]



http：// www .c-sharpcorner.com / UploadFile / 0c1bb2 / inserted-from-data-into-database-using-stored-procedure-in / [ ^ ]



关系数据链接：

使用DataSet和DataAdapter插入关系数据 [ ^ ]



Linq to SQL：

http://msdn.microsoft.com/ en-us / library / bb384428.aspx [ ^ ]



http://blogs.msdn.com/b/wriju/archive/2007/11/02/linq-to-sql -windows-form-b​​inding-data-step-by-step.aspx [ ^ ]

Basic Links :
http://www.msdotnet.co.in/2012/06/how-to-insert-data-in-database-and.html#.U7voL_mSyrE[^]

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-from-data-into-database-using-stored-procedure-in/[^]

Relational Data Links :
Inserting relational data using DataSet and DataAdapter[^]

Linq to SQL :
http://msdn.microsoft.com/en-us/library/bb384428.aspx[^]

http://blogs.msdn.com/b/wriju/archive/2007/11/02/linq-to-sql-windows-form-binding-data-step-by-step.aspx[^]

试试这个



插入table2（name_table2）值（'John'）;

插入table1（id_table2，name_table1）值\

（（选择id_table2来回m table2，其中name_table2 ='John'），'anu'）;

Try this

insert into table2(name_table2) values ('John');
insert into table1(id_table2, name_table1) values \
((select id_table2 from table2 where name_table2='John'), 'anu');

这篇关于如何将数据插入相关表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！