Datagrid Column Width

[Mike L]

This is for a Win form, in C# 2005.

I want to load a datagrid, make some columns width 0, and then clean out the
record I added.

I get the error message, ""Index was out of range. Must be non-negative and
less than the size of the collection. Parameter name: index""

I have tried, -1,0,1,2 for the index, and I get the same error message on
each try.
DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();

dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;

dt.Rows.Add(dr) ;

DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";

dgts.GridColumn Styles[-1].Width = 0;
dgPrivileges.Ta bleStyles.Add(d gts);

dt.Clear();

}
catch(Exception err)
{
MessageBox.Show (err.Message);
}

[Marc]

Mike,

Instead of going through all of the trouble of defining custom grid
styles, why not use a simple loop:

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();
dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;
dt.Rows.Add( dr );

//*************** *************** *************** ***************
foreach (DataGridViewCo lumn column in
dgPrivileges.Co lumns)
{
column.Width = 0;
}

//*************** *************** *************** ***************

dt.Clear();
}
catch (Exception err)
{
MessageBox.Show ( err.Message );
}

Marc
MCP.NET, MCAD.NET

<A href="http://www.statera.com ">Technolog y > Meet Business</A>
Mike L wrote:

This is for a Win form, in C# 2005.

I want to load a datagrid, make some columns width 0, and then clean out the
record I added.

I get the error message, ""Index was out of range. Must be non-negative and
less than the size of the collection. Parameter name: index""

I have tried, -1,0,1,2 for the index, and I get the same error message on
each try.
DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();

dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;

dt.Rows.Add(dr) ;

DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";

dgts.GridColumn Styles[-1].Width = 0;
dgPrivileges.Ta bleStyles.Add(d gts);

dt.Clear();

}
catch(Exception err)
{
MessageBox.Show (err.Message);
}

[Marc]

Mike,

I guess that really doesn't answer your question though. The real
issue is that you did not add the GridColumnStyle to the
GridTableStyle. However, something to note is that DataGridColumnS tyle
is an abstract class, in order to add a new DataGridColumnS tyle you
must either implement your own rendition of the DataGridColumnS tyle
abstract class or use one of the predefined DataGridColumnS tyles like
DataGridTextBox Column or DataGridBoolCol umn. Here is the code that
will get you the desired results:

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();
dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;
dt.Rows.Add( dr );
DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";
/*************** *************** *************** *************** *************** *************** *************** ******
DataGridColumnS tyle colStyle = new
DataGridTextBox Column();

dgts.GridColumn Styles.Add(colS tyle);

dgts.GridColumn Styles[0].Width = 0;
dgPrivileges.Ta bleStyles.Add( dgts );
/*************** *************** *************** *************** *************** *************** *************** ******
dt.Clear();
}
catch (Exception err)
{
MessageBox.Show ( err.Message );
}

[Jeffrey Tan[MSFT]]

Hi Cadel,

Thanks for your post.

I am not sure I understand your request, can you explain it in details? Why
you use -1 as the parameter of dgts.GridColumn Styles property? Because dgts
is a newly created empty DataGridTableSt yle, there are no column style in
dgts.GridColumn Styles collection, so any index passed to this property will
result in an "index out of range" exception.

For this issue, I think you should first explain to us what you want to do,
then we may provide you the correct way of doing this. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Mike L]

Your code worked but when I added column 1, 2 and 3 it come up with the error
message again.

I want the user to only see column 5 and 6. I need the other columns for
calucations I run in the background.

DataGridColumnS tyle colStyle = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle);
dgts.GridColumn Styles[0].Width = 0;
dgts.GridColumn Styles[1].Width = 0;
dgts.GridColumn Styles[2].Width = 0;
dgts.GridColumn Styles[3].Width = 200;
dgts.GridColumn Styles[4].Width = 200;
dgts.GridColumn Styles[5].Width = 0;
dgts.GridColumn Styles[6].Width = 0;
dgts.GridColumn Styles[7].Width = 0;
dgPrivileges.Ta bleStyles.Add(d gts);

"Marc" wrote:

Mike,

I guess that really doesn't answer your question though. The real
issue is that you did not add the GridColumnStyle to the
GridTableStyle. However, something to note is that DataGridColumnS tyle
is an abstract class, in order to add a new DataGridColumnS tyle you
must either implement your own rendition of the DataGridColumnS tyle
abstract class or use one of the predefined DataGridColumnS tyles like
DataGridTextBox Column or DataGridBoolCol umn. Here is the code that
will get you the desired results:

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();
dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;
dt.Rows.Add( dr );
DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";
/*************** *************** *************** *************** *************** *************** *************** ******
DataGridColumnS tyle colStyle = new
DataGridTextBox Column();

dgts.GridColumn Styles.Add(colS tyle);

dgts.GridColumn Styles[0].Width = 0;
dgPrivileges.Ta bleStyles.Add( dgts );
/*************** *************** *************** *************** *************** *************** *************** ******
dt.Clear();
}
catch (Exception err)
{
MessageBox.Show ( err.Message );
}

[Mike L]

I want the user to only see column 5 and 6. I need the other columns for
calucations I run in the background.

Here is the newest version of the code.

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();

dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;

dt.Rows.Add(dr) ;

DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";

DataGridColumnS tyle colStyle = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle);
dgts.GridColumn Styles[0].Width = 0;
dgts.GridColumn Styles[1].Width = 0;
dgts.GridColumn Styles[2].Width = 0;
dgts.GridColumn Styles[3].Width = 200;
dgts.GridColumn Styles[4].Width = 200;
dgts.GridColumn Styles[5].Width = 0;
dgts.GridColumn Styles[6].Width = 0;
dgts.GridColumn Styles[7].Width = 0;
dgPrivileges.Ta bleStyles.Add(d gts);

dt.Clear();

}
catch(Exception err)
{
MessageBox.Show (err.Message);
}

""Jeffrey Tan[MSFT]"" wrote:

Hi Cadel,

Thanks for your post.

I am not sure I understand your request, can you explain it in details? Why
you use -1 as the parameter of dgts.GridColumn Styles property? Because dgts
is a newly created empty DataGridTableSt yle, there are no column style in
dgts.GridColumn Styles collection, so any index passed to this property will
result in an "index out of range" exception.

For this issue, I think you should first explain to us what you want to do,
then we may provide you the correct way of doing this. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Jeffrey Tan[MSFT]]

Hi Cadel,

Thanks for your feedback.

Based on my understanding, you only want to show 5th and 6th column in the
DataTable in DataGrid, yes? I think we could only create 2
DataGridColumnS tyle, setting each DataGridColumnS tyle.MappingNam e to 5th
and 6th DataColumn's column name. Then, only 5th and 6th DataColumn data
will show in DataGrid. While we still can use DataTable to use other
DataColumn's data. (Because we do not want to show these columns, there is
no need for us to create DataGridColumnS tyle for these datacolumns)

Does this meet your need? Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Mike L]

Yes, I think it will meet my need, but I'm getting an error message, "Index
was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index." on dgts.GridColumn Styles[3].Width = 200;

Here is my code so far.

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();

dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;

dt.Rows.Add(dr) ;

DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";

DataGridColumnS tyle colStyle = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle);
dgts.GridColumn Styles[3].Width = 200;

DataGridColumnS tyle colStyle2 = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle2);
dgts.GridColumn Styles[4].Width = 200;
dgPrivileges.Ta bleStyles.Add(d gts);

dt.Clear();

}
catch (Exception err)
{
MessageBox.Show (err.Message);
}

""Jeffrey Tan[MSFT]"" wrote:

Hi Cadel,

Thanks for your feedback.

Based on my understanding, you only want to show 5th and 6th column in the
DataTable in DataGrid, yes? I think we could only create 2
DataGridColumnS tyle, setting each DataGridColumnS tyle.MappingNam e to 5th
and 6th DataColumn's column name. Then, only 5th and 6th DataColumn data
will show in DataGrid. While we still can use DataTable to use other
DataColumn's data. (Because we do not want to show these columns, there is
no need for us to create DataGridColumnS tyle for these datacolumns)

Does this meet your need? Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Jeffrey Tan[MSFT]]

Hi Cadel,

Thanks for your feedback.

After adding colStyle into dgts.GridColumn Styles, you should use
dgts.GridColumn Styles[0] to access this columnstyle, instead of
dgts.GridColumn Styles[3]. This is because we only add 2 columns into the
TableStyle, and our index 0 Column style just mapping to the 4th DataColumn
in the DataTable. A more safe way is directly use dgts.Width to set this
column style width.
Note: we should also modify dgts.GridColumn Styles[4] to
dgts.GridColumn Styles[1] for the same reason.

Hope this helps

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Mike L]

Changed my code, no errors but I still see all the columns and the width
didn't change for the two columns.

DataTable dt = dgPrivileges.Da taSource as DataTable;
try
{
DataRow dr = dt.NewRow();

dr[0] = 0;
dr[1] = 0;
dr[2] = 0;
dr[3] = 0;
dr[4] = 0;
dr[5] = 0;
dr[6] = 0;

dt.Rows.Add(dr) ;

DataGridTableSt yle dgts = new DataGridTableSt yle();
dgts.MappingNam e = "LicPrivilg es";

DataGridColumnS tyle colStyle = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle);
dgts.GridColumn Styles[0].Width = 200;

DataGridColumnS tyle colStyle2 = new DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle2);
dgts.GridColumn Styles[1].Width = 200;
dgPrivileges.Ta bleStyles.Add(d gts);

dt.Clear();

}
catch (Exception err)
{
MessageBox.Show (err.Message);
}

""Jeffrey Tan[MSFT]"" wrote:

Hi Cadel,

Thanks for your feedback.

After adding colStyle into dgts.GridColumn Styles, you should use
dgts.GridColumn Styles[0] to access this columnstyle, instead of
dgts.GridColumn Styles[3]. This is because we only add 2 columns into the
TableStyle, and our index 0 Column style just mapping to the 4th DataColumn
in the DataTable. A more safe way is directly use dgts.Width to set this
column style width.
Note: we should also modify dgts.GridColumn Styles[4] to
dgts.GridColumn Styles[1] for the same reason.

Hope this helps

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.