void loadData() { Purchase.database.LostData damageData = new Purchase.database.LostData(); damageData.FnConn(); DataTable dt = damageData.FillData("S", "", "spLost"); if (dt.Rows.Count > 0) { gridControl1.DataSource = dt; } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { gridView1.RefreshData(); DataTable source = gridControl1.DataSource as DataTable; DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("lostNo"); dt.Columns.Add("date"); dt.Columns.Add("remark"); dt.Columns.Add("username"); dt.Rows.Add(new object[] { txtlostno.Text, dtpdate.Text, txtremark.Text, txtuser.Text }); Purchase.database.LostData damageData = new Purchase.database.LostData(source, dt); damageData.FnConn(); damageData.fnTransactionData(); damageData.FnTrans(); MessageBox.Show("Lost list updated", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); }