public void ObtenerAppWeb(Guid UidAppWeb) { SqlCommand query = new SqlCommand(); query.CommandType = CommandType.Text; query.CommandText = "select semo.UidSegModulo, semo.VchNombre, semo.VchUrl, app.* from SegModulos semo, AppWeb app where semo.UidAppWeb = app.UidAppWeb and app.UidAppWeb = '" + UidAppWeb.ToString() + "'"; DataTable dt = this.Busquedas(query); foreach (DataRow item in dt.Rows) { appWeb = new AppWeb() { UidAppWeb = new Guid(item["UidAppWeb"].ToString()), VchNombre = item["VchNombre"].ToString(), IntGerarquia = int.Parse(item["IntGerarquia"].ToString()) }; modulos.UidSegModulo = new Guid(item["UidSegModulo"].ToString()); modulos.VchUrl = item["VchUrl"].ToString(); } }