protected void GridPrestamo_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = GridPrestamo.SelectedRow; string ConvFecha = " Convert(VARCHAR(10),Fecha,103) as Fecha "; DataTable dt = Utilitario.Lista(" Cantidad, " + ConvFecha, " from Abono ", " where PrestamoId = " + row.Cells[1].Text); DataTable dt2 = new DataTable(); dt2 = Utilitario.Lista(" ClienteId ", " from Prestamo ", " where PrestamoId = " + row.Cells[1].Text); if (dt2.Rows.Count > 0) { LblClienteId.Text = dt2.Rows[0]["ClienteId"].ToString(); DataTable dt3 = new DataTable(); dt3 = Utilitario.Lista(" Descripcion,Fecha ", " from Nota ", " where PrestamoId = " + row.Cells[1].Text); if (dt3.Rows.Count > 0) { GridComentario.DataSource = dt3; GridComentario.DataBind(); ViewState["Detalle"] = dt3; ObtenerGridView(); btnGuardarNonta.Visible = true; } else { btnGuardarNonta.Visible = false; } } if (Utilitario.ValidarTabla(dt)) { GridVAbono.DataSource = dt; GridVAbono.DataBind(); divAbono.Visible = true; lblId.Text = row.Cells[0].Text; } else { lblId.Text = row.Cells[0].Text; divAbono.Visible = false; Utilitario.ShowToastr(this, "NO TIENE ABONO", "Mensaje", "error"); } btnImprimir.Visible = true; }
public void ObtenerGridView() { GridComentario.DataSource = (DataTable)ViewState["Detalle"]; GridComentario.DataBind(); }