How do I get the column index of a datagrid from the column title?

[Moondog]

I am referencing a datagrid item like this:

strItemNo = grdItems.Item(g rdItems.Current RowIndex(), 0)
The Item Number is in the first column; column 0. It works fine
except this is not a very good programming practice. What if someday
someone decides to move the "item number" column to the fourth or
fifth position?
I'm looking for a way to reference the column index using the column
name, so I could write the statement something like this:
strItemNo = grdItems.Item(g rdItems.Current RowIndex(),
grdItems.Column ("Item Number"))
That way it doesn't matter what position the "Item Number" column is
in, the line will still work. Is there a way to do this?

Thanks,
Dominic Isaia
di****@earthlin k.net

[Imran Koradia]

Are you trying to access the contents of the currently active cell? If so,
would this work for you?

grdItems.Item(g rdItems.Current Cell.RowNumber,
grdItems.Curren tCell.ColumnNum ber)

hope this helps..
Imran.

"Moondog" <di****@earthli nk.net> wrote in message
news:42******** *************** **@posting.goog le.com...

I am referencing a datagrid item like this:

strItemNo = grdItems.Item(g rdItems.Current RowIndex(), 0)
The Item Number is in the first column; column 0. It works fine
except this is not a very good programming practice. What if someday
someone decides to move the "item number" column to the fourth or
fifth position?
I'm looking for a way to reference the column index using the column
name, so I could write the statement something like this:
strItemNo = grdItems.Item(g rdItems.Current RowIndex(),
grdItems.Column ("Item Number"))
That way it doesn't matter what position the "Item Number" column is
in, the line will still work. Is there a way to do this?

Thanks,
Dominic Isaia
di****@earthlin k.net

[VJ]

There is no direct way to access the column through name.. You could through
the dataset that is bound to the column, i.e if you are using bound data
mode. I am not sure if you do... Please refer to the following and see if
you can find anything

http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp

VJ

"Moondog" <di****@earthli nk.net> wrote in message
news:42******** *************** **@posting.goog le.com...

I am referencing a datagrid item like this:

strItemNo = grdItems.Item(g rdItems.Current RowIndex(), 0)
The Item Number is in the first column; column 0. It works fine
except this is not a very good programming practice. What if someday
someone decides to move the "item number" column to the fourth or
fifth position?
I'm looking for a way to reference the column index using the column
name, so I could write the statement something like this:
strItemNo = grdItems.Item(g rdItems.Current RowIndex(),
grdItems.Column ("Item Number"))
That way it doesn't matter what position the "Item Number" column is
in, the line will still work. Is there a way to do this?

Thanks,
Dominic Isaia
di****@earthlin k.net

[Cor Ligthert]

Moondog,

In addition to the others, it is a better way to access a datagrid through
its datasource, where is the it even better to use for that to show the
dataview.

Otherwise you can get problems as well when there the users sorts.

something as rougly typed in this message
\\\
dim dv as new dataview(mydata set.table)
dg.datasource = dv
dim cma as new currencymanger
cma = directcast(bind ingcontext(dv), currencymanager )
///
\\\
In a button item
cma.endcurrente dit
whatIwant = dv(cma.postitio n)("mycolumn")
///

I hope this helps?

Cor

I am referencing a datagrid item like this:

strItemNo = grdItems.Item(g rdItems.Current RowIndex(), 0)
The Item Number is in the first column; column 0. It works fine
except this is not a very good programming practice. What if someday
someone decides to move the "item number" column to the fourth or
fifth position?
I'm looking for a way to reference the column index using the column
name, so I could write the statement something like this:
strItemNo = grdItems.Item(g rdItems.Current RowIndex(),
grdItems.Column ("Item Number"))
That way it doesn't matter what position the "Item Number" column is
in, the line will still work. Is there a way to do this?

Thanks,
Dominic Isaia
di****@earthlin k.net

[Gene Hubert]

I had the same issue with the datagrid. See below for what I did...

You call BuildNumNameXre fGrid after you've got columnstyles added to
the grid and anytime the set of columnstyles changes (I think I need
do a hashtable.clear to handle changing the set of visible columns as
I haven't tried that yet). Then call NumFromNameGrid with the column
name to get the column number.

I have a similar set of methods that handles all columns in the
underlying datatable (not just the visible columns). This code
resides in an object that holds configuration information for how the
grid is set up (e.g. number and type of columns, column names, etc.)

Gene H.
Private Shared NumNameXrefGrid As New Hashtable

'handles visible columns in grid
Public Shared Sub BuildNumNameXre fGrid(ByVal dg As DataGrid)
Dim i As Integer
Dim dgtbc As DataGridColumnS tyle

For Each dgtbc In dg.TableStyles( 0).GridColumnSt yles
NumNameXrefGrid .Add(dgtbc.Mapp ingName, i)
i += 1
Next
End Sub

Public Shared Function NumFromNameGrid (ByVal name As String)
As Integer
Return CInt(NumNameXre fGrid(name))
End Function

di****@earthlin k.net (Moondog) wrote in message news:<42******* *************** ***@posting.goo gle.com>...

I am referencing a datagrid item like this:

strItemNo = grdItems.Item(g rdItems.Current RowIndex(), 0)
The Item Number is in the first column; column 0. It works fine
except this is not a very good programming practice. What if someday
someone decides to move the "item number" column to the fourth or
fifth position?
I'm looking for a way to reference the column index using the column
name, so I could write the statement something like this:
strItemNo = grdItems.Item(g rdItems.Current RowIndex(),
grdItems.Column ("Item Number"))
That way it doesn't matter what position the "Item Number" column is
in, the line will still work. Is there a way to do this?

Thanks,
Dominic Isaia
di****@earthlin k.net

[Moondog]

I guess there's no simple solution.
Imran: No, I'm trying to get the column number from a column name in
the datagrid.
VJ and Cor: I guess this is the only way to do it. I had made those
datasets temporary and local to my fillgrid function, so maybe I
should bump them up to global.
Thanks for your input guys,
di****@earthlin k.net

[Cor Ligthert]

Moondog,

VJ and Cor: I guess this is the only way to do it. I had made those
datasets temporary and local to my fillgrid function, so maybe I
should bump them up to global.

When you want.

You can as well use when you want
directcast(data grid.dataview,D ataview).etc any property or method

Andof course the type of the datasource you use, it can as well be datatable
or any other you are using.

I hope this gives some ideas?

Cor

[Moondog]

gwhubert,

I just implemented your solution. It works great!

Thanks again,
Moondog
di****@earthlin k.net

[Moondog]

gwhubert,

I just implemented your solution. It works great!

Thanks again,
Moondog
di****@earthlin k.net