void cargar_grilla() { tb_cxc_evalcredBL BL = new tb_cxc_evalcredBL(); tb_cxc_evalcred BE = new tb_cxc_evalcred(); TablaPendAprob = BL.GetAll_PendAprob(Session["ssEmpresaID"].ToString(), BE).Tables[0]; DataTable dtDatos = new DataTable(); if (TablaPendAprob.Rows.Count > 0) { dtDatos.Columns.Add("numdoc"); dtDatos.Columns.Add("ctactename"); dtDatos.Columns.Add("canalventaname"); dtDatos.Columns.Add("vendorname"); dtDatos.Columns.Add("imponeto"); dtDatos.Columns.Add("fecre"); string canalid = ""; string canalname = ""; for (int i = 0; i < TablaPendAprob.Rows.Count; i++) { DataRow dtRow = dtDatos.NewRow(); dtRow["numdoc"] = TablaPendAprob.Rows[i]["numdoc"].ToString(); dtRow["ctactename"] = TablaPendAprob.Rows[i]["ctactename"].ToString(); canalname = TablaPendAprob.Rows[i]["canalventaid"].ToString(); switch (canalid.ToString()) { case "01": canalname = "NO PROMOCIONALES"; break; case "02": canalname = "CLIENTES ESPECIALES"; break; case "03": canalname = "MARCAS PROMOCIONALES"; break; default: canalname = "NO PROMOCIONALES"; break; } dtRow["canalventaname"] = canalname.ToString(); dtRow["vendorname"] = TablaPendAprob.Rows[i]["vendorname"].ToString(); dtRow["imponeto"] = TablaPendAprob.Rows[i]["imponeto"].ToString(); dtRow["fecre"] = TablaPendAprob.Rows[i]["fecre"].ToString().Substring(0,10); dtDatos.Rows.Add(dtRow); } GridView.DataSource = dtDatos; GridView.DataBind(); } }
void cargar_grilla() { tb_cxc_evalcredBL BL = new tb_cxc_evalcredBL(); tb_cxc_evalcred BE = new tb_cxc_evalcred(); TablaPendAprob = BL.GetAll_PendAprob("02", BE).Tables[0]; if (TablaPendAprob.Rows.Count > 0) { GridView.DataSource = TablaPendAprob; GridView.DataBind(); } }