private void SetInitialRow_ItemRateDtls() { try { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("#", typeof(int)); dt.Columns.Add("PONo", typeof(string)); dt.Columns.Add("PODate", typeof(string)); dt.Columns.Add("ItemCode", typeof(string)); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("OrderQuantity", typeof(string)); dt.Columns.Add("Rate", typeof(string)); dt.Columns.Add("Amount", typeof(string)); dt.Columns.Add("Location", typeof(string)); dt.Columns.Add("PORate", typeof(string)); dt.Columns.Add("RateDiff", typeof(string)); dr = dt.NewRow(); dr["#"] = 0; dr["PONo"] = ""; dr["PODate"] = ""; dr["ItemCode"] = ""; dr["ItemName"] = ""; dr["OrderQuantity"] = ""; dr["Rate"] = ""; dr["Amount"] = ""; dr["Location"] = ""; dr["PORate"] = ""; dr["RateDiff"] = ""; dt.Rows.Add(dr); ViewState["CurrentTableItemRateDtls"] = dt; GrdItemWiseRate.DataSource = dt; GrdItemWiseRate.DataBind(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void BindPurchaseOrderLastRatesDetails(string Cond, Decimal NewRate) { try { Ds = Obj_EditPO.GetRateCompare(Cond, NewRate, 0, out StrError); //Ds = Obj_EditPO.GetRateCompare(Cond, 0,0, out StrError); if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0) { GrdItemWiseRate.DataSource = Ds.Tables[0]; GrdItemWiseRate.DataBind(); } else { GrdItemWiseRate.DataSource = null; GrdItemWiseRate.DataBind(); SetInitialRow_ItemRateDtls(); } } catch (Exception ex) { throw new Exception(ex.Message); } }