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);
}
