Why doesn't DataGridTableSt yle work?

[Brett Romero]

I can't find what exactly I'm doing wrong that the following
DataGridTableSt yle is not working on my table. The result set returns
21 columns. I'm only formatting 5 via the TableStyle. I thought maybe
the problem was I had more columns being put into the DataGrid than I
was formatting. I then created a new table and adding only the five
mapped columns to it. That didn't help either.

I'm hiding column 3 because I need its value but don't want it
displayed. I do get the five columns output into the grid but no
styling. Any suggestions:

DataTable dt = new DataTable();

DataGridTableSt yle participantGrid TableStyle = new
DataGridTableSt yle();
participantGrid TableStyle.Mapp ingName = dt.TableName;

// Create GridColumnStyle objects for the grid columns
//First five columns are: PersonId, PersonCode, FirstName,
MiddleName, LastName

DataGridTextBox Column partCol1 = new DataGridTextBox Column();
DataGridTextBox Column partCol2 = new DataGridTextBox Column();
DataGridTextBox Column partCol3 = new DataGridTextBox Column();
DataGridTextBox Column partCol4 = new DataGridTextBox Column();
DataGridTextBox Column partCol5 = new DataGridTextBox Column();

partCol1.Mappin gName = "PersonId";
partCol2.Mappin gName = "PersonCode ";

//hide column 3
partCol3.Mappin gName = "FirstName" ;
partCol3.Width = 0;

partCol4.Mappin gName = "MiddleName ";

partCol5.Mappin gName = "LastName";
//just to see if style is outputting
partCol5.Header Text = "Last | Name";
partCol5.
partCol5.Width = 65;
partCol5.Alignm ent = HorizontalAlign ment.Left;
partCol5.TextBo x.Enabled = false;

// Add the GridColumnStyle s to the DataGrid's Column Styles
collection.
// Place the "ID" column (column 1) last since it is not visible.

participantGrid TableStyle.Grid ColumnStyles.Ad d(partCol1);
participantGrid TableStyle.Grid ColumnStyles.Ad d(partCol2);
participantGrid TableStyle.Grid ColumnStyles.Ad d(partCol3);
participantGrid TableStyle.Grid ColumnStyles.Ad d(partCol4);
participantGrid TableStyle.Grid ColumnStyles.Ad d(partCol5);

dt = (Searching.Find Participants()) .Tables[0];

//dt.TableName will now be "Table" because of above assignement.
dt.TableName = "ParticipantSea rch";

DataTable dtLimit = dt.Copy();;
//restrict to only five columns
int x = 5;
while (x < dtLimit.Columns .Count)
{
dtLimit.Columns .RemoveAt(x);
Debug.WriteLine (dt.Columns[x].ColumnName);
}

Participant.Tab leStyles.Clear( );
Participant.Tab leStyles.Add(pa rticipantGridTa bleStyle);

this.Participan t.DataSource = dtLimit;
Participant.Exp and(-1);
Participant.Nav igateTo(0, dt.TableName);

Thanks,
Brett

[Steven Nagy]

Well I am not sure if this is it or not but....

You have this line:

participantGrid TableStyle.Mapp ingName = dt.TableName;

Then later on you have this line:

dt.TableName = "ParticipantSea rch";

Which means your DGTS is mapping to a table that doesn't really exist.

Try putting the MappingName assignment lower down.

Steven Nagy

[Brett Romero]

Glad you posted back to this Steven. You are right. The problem was a
combination of what you mentioned and previously this line resetting
the table name.

dt = (Searching.Find Participants()) .Tables[0];

It reset the dt table back to "Table". That's why this line now
follows it.

dt.TableName = "ParticipantSea rch";

Thanks,
Brett