private void autofillButton_Click(object sender, EventArgs e) { SvodVedomostGetPacketsForm tmpForm = new SvodVedomostGetPacketsForm(_org, RepYear, _connection); DialogResult dRes = tmpForm.ShowDialog(this); if (dRes == DialogResult.OK) { long[] markedPacked = tmpForm.MarckedPackets; long[] doctypes = { 21, 22, 24 }; DataTable salaryInfoTranspose = SalaryInfoTranspose.CreateTableWithRows(); if (markedPacked.Length > 0) { DataTable salaryInfoTable = SalaryInfo.CreateTable(); SQLiteDataAdapter adapter = new SQLiteDataAdapter(SalaryInfo.GetSelectText(markedPacked, doctypes), _connection); adapter.Fill(salaryInfoTable); SalaryInfoTranspose.ConvertFromSalaryInfo(salaryInfoTranspose, salaryInfoTable); packetcountBox.Value = markedPacked.Length; documentcountBox.Value = Docs.Count(markedPacked, _connection); // (long)salaryInfoTable.Rows[0][SalaryInfo.docId]; } else { packetcountBox.Value = 0; documentcountBox.Value = 0; } int i; for (i = 0; i < 12; i++) { _svodTable.Rows[i][SalaryGroups.Column1] = salaryInfoTranspose.Rows[i][SalaryGroups.Column1]; _svodTable.Rows[i][SalaryGroups.Column2] = salaryInfoTranspose.Rows[i][SalaryGroups.Column2]; _svodTable.Rows[i][SalaryGroups.Column3] = salaryInfoTranspose.Rows[i][SalaryGroups.Column3]; _svodTable.Rows[i][SalaryGroups.Column4] = salaryInfoTranspose.Rows[i][SalaryGroups.Column4]; _svodTable.Rows[i][SalaryGroups.Column5] = salaryInfoTranspose.Rows[i][SalaryGroups.Column5]; _svodTable.Rows[i].EndEdit(); _svodTable.AcceptChanges(); } } }