private void GetBooks() { try { int pos = bookBindingSource.Position; dsBooks = BooksListDataSetFiller.FillData(SelectedAccount.Instance.AccountId); bookBindingSource.DataSource = dsBooks; bookBindingSource.Position = pos; } catch (Exception ex) { MessageBox.Show(ex.Message + "\n\n" + ex.StackTrace, "Ooops!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static BooksListDS FillData(int account) { BooksListDS _dsDestination = new BooksListDS(); using (bookTableAdapter _taSource = new bookTableAdapter()) { accountingDataSet.bookDataTable _tblSource = _taSource.GetData(account); foreach (accountingDataSet.bookRow row in _tblSource.Rows) { _dsDestination.Tables["Book"].Rows.Add(new object[] { row.bookId, row.account, row.booktype, row.title, row.created }); } } return _dsDestination; }