我做不到,发现如何在与单个主键关联的单个列中插入多个值。
- 我已为主键(程序包ID)启用了自动递增
-
serviceidF是外键
for (int i = 0; i < 2; i++) { if (i == 0) { query = "Insert Into tbl_Packages (packageName,packagePrice,serviceId_F) values ('" + _ppnm3 + "','" + _pppM3 + "','" + _i1M3 + "')"; cmd = new SqlCommand(query,PC.connect()); cmd.ExecuteNonQuery(); PC.disconnect(); } else if (i == 1) { query1 = "Insert Into tbl_Packages (packageName,'" + _i2M3 + "')"; cmd1 = new SqlCommand(query1,PC.connect()); cmd1.ExecuteNonQuery(); PC.disconnect(); } }