hi,
i try to set row cell value but this error appear at this line
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "storeID", BasicVars.DeafulStore);
MessageBox appeared an it say :
Object reference set to an instance of an object
but there is no any other details:
the full code
private void AddNewRowWithChossedFromSearchLookUpEdit(int CHK_itemID)
{
if (CHK_itemID == 0) return;
mrsalesdbEntities DB01 = ConnectionTools.OpenConn();
var ItemData = DB01.st_items.Find(CHK_itemID);
gridView1.AddNewRow();
int rowHandle = gridView1.FocusedRowHandle;
decimal taxPercent = 0;
try
{
if (ItemData.stitems_HaveTax == 1)
{
taxPercent = ItemData.stitems_TaxValue.Value;
}
else { taxPercent = 0; }
}
catch
{
taxPercent = 0;
}
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "taxp", taxPercent);
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "storeID", BasicVars.DeafulStore);
var DB02 = ConnectionTools.OpenConn();
var UnitItemData = LoadedUnits.Where(u => u.stitems_ID == CHK_itemID).OrderBy(o => o.stitemsu_UnitNum).FirstOrDefault();
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "unit_ID", UnitItemData.stitemsu_ID);
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "sitem_Quantity", 1);
if (gridView1.GetFocusedRowCellValue("stitems_ID") != null || gridView1.GetFocusedRowCellValue("unit_ID") != null ||
gridView1.GetFocusedRowCellValue("sitem_Quantity") != null)
{
int UnitID = Convert.ToInt32(gridView1.GetFocusedRowCellValue("unit_ID"));
GetUnitDetails(UnitID);
GetBounce(UnitID);
}
int StoreID = Convert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "storeID"));
int itemID = CHK_itemID;
try
{
ExpiredDateCombo.Items.Clear();
if (ItemData.stitems_Type.Value == 0)
{
var DB0201 = ConnectionTools.OpenConn();
var EXdates = DB0201.stock_noserials.Where(u => u.stitems_ID == CHK_itemID && u.StoreID == StoreID && u.StockQnty > 0).OrderBy(o => o.ExpireDate).ToList();
foreach (var d in EXdates)
{
ExpiredDateCombo.Items.Add(d.ExpireDate.Value.ToString("yyyy-MM-dd"));
}
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "ExpiredDate", EXdates.FirstOrDefault().ExpireDate.Value.ToString("yyyy-MM-dd"));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "BatchNum", EXdates.FirstOrDefault().BatchNum.ToString());
}
else if (ItemData.stitems_Type.Value == 1)
{
var DB0201 = ConnectionTools.OpenConn();
var EXdates = DB0201.purchases_item_seriels.Where(u => (u.stitems_ID == CHK_itemID && u.ss_StoreID == StoreID && u.pis_Statues == 0) ||
(u.stitems_ID == CHK_itemID && u.ss_StoreID == StoreID && u.pis_Statues == 5) ||
(u.stitems_ID == CHK_itemID && u.ss_StoreID == StoreID && u.pis_Statues == 6)).OrderBy(o => o.pis_ExpireDate).ToList();
foreach (var d in EXdates)
{
ExpiredDateCombo.Items.Add(d.pis_ExpireDate.Value.ToString("yyyy-MM-dd"));
}
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "ExpiredDate", EXdates.FirstOrDefault().pis_ExpireDate.Value.ToString("yyyy-MM-dd"));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "BatchNum", EXdates.FirstOrDefault().BatchNum.ToString());
}
}
catch {
}
gridView1.ClearColumnErrors();
PathingVars.RowValid = 1;
ClearValidationsErrs = 0;
gridView1.PostEditor();
gridView1.UpdateCurrentRow();
gridView1.FocusedRowHandle = gridView1.DataRowCount - 1;
gridView1.FocusedColumn = gridView1.Columns["sitem_NetPrice"];
}
What I have tried:
i tried to write this line between try and catch to see the error details but no msg. appeared
try
{
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "storeID", BasicVars.DeafulStore);
}
catch (Exception exxxxx) { MessageBox.Show(exxxxx.ToString()); }
please note that the "
storeID" is a column in
gridView1 and ,
BasicVars.DeafulStore have value "1" and not null.