protected void GRDOUTSTANDINGPO_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case ("Select"): { DataSet DSInwardDetails = new DataSet(); StrCondition = string.Empty; StrCondition = " AND C.SuplierId=" + e.CommandArgument; DSInwardDetails = Obj_PO.GetPOForStatusReportOSSupplierItems(StrCondition, out StrError); if (DSInwardDetails.Tables.Count > 0 && DSInwardDetails.Tables[0].Rows.Count > 0) { GRDSUPLIEROSREPORT.DataSource = DSInwardDetails.Tables[0]; GRDSUPLIEROSREPORT.DataBind(); MergeRows(GRDSUPLIEROSREPORT); GRDSUPLIEROSREPORT.Visible = true; } else { GRDSUPLIEROSREPORT.DataSource = null; GRDSUPLIEROSREPORT.DataBind(); GRDSUPLIEROSREPORT.Visible = false; } } break; } } catch (Exception ex) { } }
private void SetInitialRowGRDOUTSTANDINGITEM() { try { DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("#", typeof(Int32))); dt.Columns.Add(new DataColumn("SuplierName", typeof(string))); dt.Columns.Add(new DataColumn("pono", typeof(string))); dt.Columns.Add(new DataColumn("ItemName", typeof(string))); dt.Columns.Add(new DataColumn("ItemDesc", typeof(string))); dt.Columns.Add(new DataColumn("RemarkForPo", typeof(string))); dt.Columns.Add(new DataColumn("Unit", typeof(string))); dt.Columns.Add(new DataColumn("sumpoqty", typeof(string))); dt.Columns.Add(new DataColumn("suminqty", typeof(string))); dt.Columns.Add(new DataColumn("BalanceQty", typeof(string))); dr = dt.NewRow(); dr["#"] = 0; dr["SuplierName"] = ""; dr["pono"] = ""; dr["ItemName"] = ""; dr["ItemDesc"] = ""; dr["RemarkForPo"] = ""; dr["Unit"] = ""; dr["sumpoqty"] = ""; dr["suminqty"] = ""; dr["BalanceQty"] = ""; dt.Rows.Add(dr); ViewState["CurrentTable"] = dt; GRDSUPLIEROSREPORT.DataSource = dt; GRDSUPLIEROSREPORT.DataBind(); dt = null; dr = null; } catch (Exception ex) { throw new Exception(ex.Message); } }