protected void ButtonAgrOpcionN2_Click(object sender, EventArgs e)
{
SqlConnection con;
SqlCommand cmd = new SqlCommand();
String Perfil = DropDownPerfil.SelectedValue;
String Opcion = DropDownListOpcionPagN2.SelectedValue;
int i = GridViewMenu_N0.SelectedIndex;
Label Modulo = (Label)GridViewMenu_N0.Rows[i].FindControl("Modulo");
int j = GridViewMenu_N1.SelectedIndex;
Label OpcionN1 = (Label)GridViewMenu_N1.Rows[j].FindControl("Opcion");
int Posicion = GridViewMenu_N2.Rows.Count + 1;
con = new SqlConnection(BopDBModulos.ConnectionString);
cmd.Connection = con;
con.Open();
try
{
cmd.CommandText = "INSERT INTO [dbo].[Menu_N2] ([Perfil],[Modulo],[Posicion],[Opcion1],[Opcion2]) VALUES('" + Perfil.Trim() + "','" + Modulo.Text.Trim() + "'," + Posicion.ToString() + ",'" + OpcionN1.Text.Trim() + "','" + Opcion.Trim() + "')";
cmd.ExecuteNonQuery();
GridViewMenu_N2.DataBind();
}
catch (SqlException exception)
{
if (exception.Number == 2601) // Cannot insert duplicate key row in object error
{
return;
}
}
}
protected void GridViewMenu_N1_SelectedIndexChanged(object sender, EventArgs e)
{
int i = GridViewMenu_N1.SelectedIndex;
Label Opcion = (Label)GridViewMenu_N1.Rows[i].FindControl("Opcion");
OpcionSel.Text = Opcion.Text;
GridViewMenu_N2.SelectedIndex = -1;
GridViewMenu_N2.DataBind();
}