Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dataAdapter.Fill(dataSet);
- string stsql = "INSERT INTO tech.rel_zakaz_doc(id_zakaz, id_doc) VALUES(:p1, :p2)";
- NpgsqlDataAdapter da = new NpgsqlDataAdapter(??????????????????????);
- da.InsertCommand = new NpgsqlCommand(stsql, pqconn);
- da.InsertCommand.Parameters.Add(new NpgsqlParameter("v1", NpgsqlDbType.Integer));
- da.InsertCommand.Parameters.Add(new NpgsqlParameter("v2", NpgsqlDbType.Integer));
- da.InsertCommand.Parameters[0].Direction = ParameterDirection.Input;
- da.InsertCommand.Parameters[1].Direction = ParameterDirection.Input;
- da.InsertCommand.Parameters[0].SourceColumn = "id_zakaz";
- da.InsertCommand.Parameters[1].SourceColumn = "id_doc";
- DataTable firstTable = dataSet.Tables[0];
- if (firstTable != null)
- {
- da.Update(firstTable);//аргументом может быть таблица, набор записей
- firstTable.Dispose();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement