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));
}
