Modify a single column in a datagrid?

[Bruce D]

Is there a way to programatically set the format of just one column in a
datagrid? I have a datagrid bined to a datasource. My dataview has 6
columns. And I want to format one column ('amount')...wi thout have to mess
with all the other columns.
If I use DataGridTableSt yle() and DataGridTextBox Column() (see following
code)...my datagrid only displays 1 column!

Dim dvFinders As New DataView(dtFind ers)
DataGrid1.DataS ource = dvFinders
' set properties
Dim x As New DataGridTableSt yle
x.MappingName = "Finders"
Dim z As New DataGridTextBox Column
z.MappingName = "lastname"
z.Width = 150
x.GridColumnSty les.Add(z)
DataGrid1.Table Styles.Add(x)

This datagrid is making my project a lot harder than it should be!

Any help is appreciated!
-bruce duncan

[Chris, Master of All Things Insignificant]

If you are going to use DataTable for one column, you'll need to add one for
each column you want to display. If you don't want to add a tablestyle for
each column, then add a column to your datatable (dataview has a datatable)
and for the column directly on the datatable.

Chris
"Bruce D" <br************ *@hotmail.com> wrote in message
news:11******** *****@corp.supe rnews.com...

Is there a way to programatically set the format of just one column in a
datagrid? I have a datagrid bined to a datasource. My dataview has 6
columns. And I want to format one column ('amount')...wi thout have to
mess
with all the other columns.
If I use DataGridTableSt yle() and DataGridTextBox Column() (see following
code)...my datagrid only displays 1 column!

Dim dvFinders As New DataView(dtFind ers)
DataGrid1.DataS ource = dvFinders
' set properties
Dim x As New DataGridTableSt yle
x.MappingName = "Finders"
Dim z As New DataGridTextBox Column
z.MappingName = "lastname"
z.Width = 150
x.GridColumnSty les.Add(z)
DataGrid1.Table Styles.Add(x)

This datagrid is making my project a lot harder than it should be!

Any help is appreciated!
-bruce duncan

[Chris, Master of All Things Insignificant]

*Corrected wording

If you are going to use DataGridTableSt yle for one column, you'll need to
add one for each column you want to display. If you don't want to add a
DataGridTableSt yle for each column, then add a column to your datatable
(dataview has a datatable) and for the column directly on the datatable.

Chris

"Chris, Master of All Things Insignificant" <chris@No_Spam_ Please.com> wrote
in message news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..

If you are going to use DataTable for one column, you'll need to add one
for each column you want to display. If you don't want to add a
tablestyle for each column, then add a column to your datatable (dataview
has a datatable) and for the column directly on the datatable.

Chris
"Bruce D" <br************ *@hotmail.com> wrote in message
news:11******** *****@corp.supe rnews.com...

Is there a way to programatically set the format of just one column in a
datagrid? I have a datagrid bined to a datasource. My dataview has 6
columns. And I want to format one column ('amount')...wi thout have to
mess
with all the other columns.
If I use DataGridTableSt yle() and DataGridTextBox Column() (see following
code)...my datagrid only displays 1 column!

Dim dvFinders As New DataView(dtFind ers)
DataGrid1.DataS ource = dvFinders
' set properties
Dim x As New DataGridTableSt yle
x.MappingName = "Finders"
Dim z As New DataGridTextBox Column
z.MappingName = "lastname"
z.Width = 150
x.GridColumnSty les.Add(z)
DataGrid1.Table Styles.Add(x)

This datagrid is making my project a lot harder than it should be!

Any help is appreciated!
-bruce duncan

[Bruce D]

Thanks Chris!
How about another question? I have a DataTable that has both lastname,
firstname as seperate fields. How can I display them as one field in the
datagrid (and yes...I was forced to use DataGridTableSt yle for each column)?

TIA
-bruce
"Chris, Master of All Things Insignificant" <chris@No_Spam_ Please.com> wrote
in message news:Ox******** ******@TK2MSFTN GP15.phx.gbl...

*Corrected wording

If you are going to use DataGridTableSt yle for one column, you'll need to
add one for each column you want to display. If you don't want to add a
DataGridTableSt yle for each column, then add a column to your datatable
(dataview has a datatable) and for the column directly on the datatable.

Chris

[Chris, Master of All Things Insignificant]

I assume you are getting your data out of a database? In that case I would
do it in your select statement.

Select FirstName + ' ' + LastName as Name, TableName.* from TableName

There may be a nice slick way of doing it client side, but this is how I've
always done stuff like that.
Chris
"Bruce D" <br************ *@hotmail.com> wrote in message
news:11******** *****@corp.supe rnews.com...

Thanks Chris!
How about another question? I have a DataTable that has both lastname,
firstname as seperate fields. How can I display them as one field in the
datagrid (and yes...I was forced to use DataGridTableSt yle for each
column)?

TIA
-bruce
"Chris, Master of All Things Insignificant" <chris@No_Spam_ Please.com>
wrote
in message news:Ox******** ******@TK2MSFTN GP15.phx.gbl...

*Corrected wording

If you are going to use DataGridTableSt yle for one column, you'll need
to
add one for each column you want to display. If you don't want to add a
DataGridTableSt yle for each column, then add a column to your datatable
(dataview has a datatable) and for the column directly on the datatable.

Chris

[Bruce D]

Thanks for the response, but I was looking for the client side answer.

-bruce

"Chris, Master of All Things Insignificant" <chris@No_Spam_ Please.com> wrote
in message news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

I assume you are getting your data out of a database? In that case I would do it in your select statement.

Select FirstName + ' ' + LastName as Name, TableName.* from TableName

There may be a nice slick way of doing it client side, but this is how I've always done stuff like that.
Chris