You're right, my code for databounding the grid is this. I get both tables and create the relation.
private DataSet returnTipoasset(int TasCodigo)
{
DataSet dtsInformacion = new DataSet();
Tipoasset.Criteria objCT = new TipoassetBase.Criteria();
objCT.AgregarEntidadCriteria(Tipoasset.TipoFiltro.Add, Tipoasset.OperadordeComparacion.Equal,
Tipoasset.IndiceCampo.TasEstadoIndex, "AC");
if (TasCodigo != new Tipoasset().TasCodigo)
{
objCT.AgregarEntidadCriteria(Tipoasset.TipoFiltro.Add, Tipoasset.OperadordeComparacion.Equal,
Tipoasset.IndiceCampo.TasCodigoIndex, TasCodigo);
}
dtsInformacion.Tables.Add(new Tipoasset().FetchMultiDataTable(objCT));
VwAssets.Criteria objCriteria = new VwAssetsBase.Criteria();
objCriteria.AgregarEntidadCriteria(VwAssets.TipoFiltro.Add, VwAssets.OperadordeComparacion.Equal,
VwAssets.IndiceCampo.CliCodigoIndex, Convert.ToDecimal(11));
if (TasCodigo != new Tipoasset().TasCodigo)
{
objCriteria.AgregarEntidadCriteria(VwAssets.TipoFiltro.Add, VwAssets.OperadordeComparacion.Equal,
VwAssets.IndiceCampo.TasCodigoIndex, TasCodigo);
}
dtsInformacion.Tables.Add(new VwAssets().FetchMultiDataTable(objCriteria));
DataColumn[ parentCol = new DataColumn[1] { dtsInformacion.Tables[0].Columns["TasCodigo"] };
DataColumn[ childCol = new DataColumn[1] { dtsInformacion.Tables[1].Columns["TasCodigo"] };
DataRelation dr;
dr = new DataRelation("RelacionGrid", parentCol, childCol, false);
dtsInformacion.Relations.Add(dr);
return dtsInformacion;
}
but, when I execute this code
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow rowBanda0 in dgAssets.Rows)
{
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in rowBanda0.Rows)
{
string[ NoShow = null;
if (row.Cells.FromKey("TasCodigo").Text == "1") // Kind Company -- Hide Columns not this kind
{
NoShow = new string[ {
"AfoFoundationName",
"AfoJurisdition",
"AfoIdNumber",
"AfoStatus",
"AfoIncorporationDate" };
}
else if (row.Cells.FromKey("TasCodigo").Text == "3") // Kind Foundation -- Hide Columns not this kind
{
NoShow = new string[ {
"AcoCompanyName",
"AcoJurisdition",
"AcoId",
"AcoDateIncorporation",
"AcoStatus" };
}
if (NoShow != null)
{
foreach (string campo in NoShow)
{
//row.Cells.FromKey(campo).Style.CssClass = "Hidden";
row.Cells.FromKey(campo).Column.Hidden = true;
}
}
}
}
I get this grid, I can't see the information about Company and Foundation, because I hide the columns, but how can I hide the columns in some rows, not in all at them?
