void carga_subcategorias(int id_categoria) { string sql = ""; sql = "select ID_SubCategoria ID, Nombre Subacategoria, IIF(activo=1,'SI','NO') Activo from tbl_SubCategorias where Id_Categoria = " + id_categoria; sql = "select ID_SubCategoria ID, Nombre Subacategoria, IIF(activo = 1, 'SI', 'NO') Activo, "; sql = sql + "(select COUNT(1) from tbl_Items where Id_Categoria = tbl_SubCategorias.Id_Categoria and Id_SubCategoria = tbl_SubCategorias.Id_SubCategoria) Productos, "; sql = sql + "(select COUNT(1) from tbl_Items_web where Id_Categoria = tbl_SubCategorias.Id_Categoria and Id_SubCategoria = tbl_SubCategorias.Id_SubCategoria) Publicados "; sql = sql + "from tbl_SubCategorias where Id_Categoria = " + id_categoria; using (SqlConnection connection = new SqlConnection(Sserver)) { try { connection.Open(); //SqlCommand command = new SqlCommand(sql, connection); SqlDataAdapter reader = new SqlDataAdapter(sql, connection); DataSet dr = new DataSet(); reader.Fill(dr, "tbl_SubCategorias"); LstSubCategorias.DataSource = dr; LstSubCategorias.DataBind(); connection.Close(); connection.Dispose(); } catch (Exception ex) { lbl_error.Text = ex.Message; connection.Close(); connection.Dispose(); } } }
protected void Lst_division_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = Lst_division.SelectedRow; //lbl_status.Text = row.Cells[1].Text; lbl_familia.Text = row.Cells[2].Text; id_familia = Convert.ToInt32(row.Cells[1].Text); LstCategorias.DataSource = null; LstCategorias.DataBind(); LstSubCategorias.DataSource = null; LstSubCategorias.DataBind(); carga_categorias(Convert.ToInt32(row.Cells[1].Text)); }