void BindData(string VbConsultar) { DataTable dtbl = new DataTable(); Cnx.BaseDatos(Session["D[BX"].ToString(), Session["$VR"].ToString(), Session["V$U@"].ToString(), Session["P@$"].ToString()); using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex())) { string VbTxtSql = "EXEC SP_ConfiguracionV2_ 12,'" + VbConsultar + "','','','','',0,0,0,0,'01-01-1','02-01-1','03-01-1'"; sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(VbTxtSql, sqlCon); sqlDa.Fill(dtbl); } if (dtbl.Rows.Count > 0) { GrdDatos.DataSource = dtbl; GrdDatos.DataBind(); } else { dtbl.Rows.Add(dtbl.NewRow()); GrdDatos.DataSource = dtbl; GrdDatos.DataBind(); GrdDatos.Rows[0].Cells.Clear(); GrdDatos.Rows[0].Cells.Add(new TableCell()); GrdDatos.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count; GrdDatos.Rows[0].Cells[0].Text = "No existen registros ..!"; GrdDatos.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; } }
protected void GrdDatos_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { string vble; vble = (GrdDatos.Rows[e.RowIndex].FindControl("TxtPos") as TextBox).Text.Trim(); if (vble == String.Empty) { //ScriptManager.RegisterClientScriptBlock(this.UpPanel, UpPanel.GetType(), "IdntificadorBloqueScript", "alert('Debe ingresar una posición')", true); return; } string VbPosisicones = (GrdDatos.Rows[e.RowIndex].FindControl("TxtPos") as TextBox).Text.Trim() + (GrdDatos.Rows[e.RowIndex].FindControl("TxtPosSup") as TextBox).Text.Trim() + (GrdDatos.Rows[e.RowIndex].FindControl("TxtPosMaster") as TextBox).Text.Trim(); Cnx.BaseDatos(Session["D[BX"].ToString(), Session["$VR"].ToString(), Session["V$U@"].ToString(), Session["P@$"].ToString()); using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex())) { sqlCon.Open(); string query = "EXEC SP_ConfiguracionV2_ 5,@Posiciones,@Descr,@Ruta,@NomForm,'',@Nivel,@id,0,0,'01-01-01','02-01-01','03-01-01'"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@Posiciones", VbPosisicones); sqlCmd.Parameters.AddWithValue("@Descr", (GrdDatos.Rows[e.RowIndex].FindControl("TxtIdDescr") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@Nivel", (GrdDatos.Rows[e.RowIndex].FindControl("TxtNivel") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@Ruta", (GrdDatos.Rows[e.RowIndex].FindControl("TxtRuta") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@NomForm", (GrdDatos.Rows[e.RowIndex].FindControl("TxtNomForm") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(GrdDatos.DataKeys[e.RowIndex].Value.ToString())); sqlCmd.ExecuteNonQuery(); GrdDatos.EditIndex = -1; BindData(TxtBusqueda.Text); } } catch (Exception ex) { ClsConexion ClsUE = new ClsConexion(); ClsUE.UpdateError(Session["C77U"].ToString(), "FrmMenu", "Update", "0", ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString()); } }
protected void GrdPerfilAsig_RowDeleting(object sender, GridViewDeleteEventArgs e) { if ((int)Session["IdGrupoRP"] != 0) { Cnx.BaseDatos(Session["D[BX"].ToString(), Session["$VR"].ToString(), Session["V$U@"].ToString(), Session["P@$"].ToString()); using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex())) { sqlCon.Open(); string query = "DELETE FROM TblUsrPerfiles WHERE CodidUsrPerfil = @ID"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@ID", Convert.ToInt32(GrdPerfilAsig.DataKeys[e.RowIndex].Value.ToString())); sqlCmd.ExecuteNonQuery(); ActivarControles(); BindData(TxtBusqueda.Text, TxtBusqUsu.Text, "UPD"); } } }