public void LlenarGridPermisos()
{
/*SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings.Get("strConnection"));*/
string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection cnn;
cnn = new SqlConnection(conexion);
cnn.Open();
SqlCommand comando = new SqlCommand("SP_Catalgo_Permisos", cnn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Opcion", "LISTADO");
SqlDataAdapter da = new SqlDataAdapter(comando);
DataTable ds = new DataTable();
da.Fill(ds);
Grid_Permisos.Visible = true;
Grid_Permisos.DataSource = ds;
Grid_Permisos.Columns[0].Visible = true;
Grid_Permisos.Columns[1].Visible = true;
Grid_Permisos.DataBind();
Grid_Permisos.Columns[0].Visible = false;
ds.Dispose();
da.Dispose();
}
public void LlenarGridPermisos2()
{
/*SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings.Get("strConnection"));*/
string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection cnn;
cnn = new SqlConnection(conexion);
cnn.Open();
int numeroidperfil2 = Convert.ToInt32(ddl_Id_Perfil.SelectedValue);
SqlCommand comando = new SqlCommand("SP_Catalgo_Permisos2", cnn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Opcion", "LISTADO");
comando.Parameters.AddWithValue("@Id_Perfil", numeroidperfil2);
SqlDataAdapter da = new SqlDataAdapter(comando);
DataTable ds = new DataTable();
da.Fill(ds);
//Session["usuario"] = ds;
Grid_Permisos.Visible = true;
Grid_Permisos.DataSource = ds;
Grid_Permisos.Columns[0].Visible = true;
Grid_Permisos.Columns[1].Visible = true;
Grid_Permisos.Columns[2].Visible = true;
Grid_Permisos.DataBind();
CheckBox chseleccionado;
foreach (GridViewRow row in Grid_Permisos.Rows)
{
bool valorcheck = false;
valorcheck = Convert.ToBoolean(row.Cells[2].Text);
chseleccionado = row.FindControl("CheckBoxelegir") as CheckBox;
if (valorcheck == true)
{
chseleccionado.Checked = true;
}
else
{
chseleccionado.Checked = false;
}
}
Grid_Permisos.Columns[0].Visible = false;
Grid_Permisos.Columns[2].Visible = false;
ds.Dispose();
da.Dispose();
cnn.Close();
}
