9Rays.Net - Forums - .NET - FlyGrid.Net (Windows Forms) - Select row in grid and grab infomation for that rows columns

Home - Forums-.NET - FlyGrid.Net (Windows Forms) - Select row in grid and grab infomation for that rows columns

FlyGrid.Net (Windows Forms)

.NET Datagrid - Fast, highly customizable, industry standards .NET data grid control for WinForms

This forum related to following products: FlyGrid.Net

Select row in grid and grab infomation for that rows columns

Link Posted: 18-Sep-2006 01:53

GrannyKlump

Total Posts:0

Joined:4/4/2025

I have the 9rays grid on a form and i would like to get all the data (columns) that are on that selected row. how would i do this in VB.net?

I am using this code snippet to get the row index of the selected row.
SelectedRow = FlyGrid1.Selected.Index

now, i just need the code to get all the data for the selected rows columns.

Thanks,
GK

Link Posted: 20-Sep-2006 08:54

NineRays

Total Posts:0

Joined:4/4/2025

You can use following code:

[VB.Net]
Private Sub populateCellsOfSelectedNode(ByVal flyGrid As FlyGrid)
  'get the selected node
  Dim node As NodeBase = flyGrid.Selected
  'populate cells values for the visible columns
  For i As Integer = 0 To flyGrid.Columns.VisibleColumns.Length - 1
    Dim column As Column = flyGrid.Columns.VisibleColumns(i)
    System.Console.WriteLine(String.Format(\"Cell: {0}, Value: {1}\", column.Caption, node(column)))
  Next i
End Sub

Link Posted: 21-Sep-2006 08:50

GrannyKlump

Total Posts:0

Joined:4/4/2025

ok, that works but i have another question that is related.

how can i grab the data without using a loop and by specifing the column name?

something like:

messagebox.show(flyGrid.Columns.VisibleColumns(\"userlogon\"))

is that possible?

thanks!
GK

Link Posted: 21-Sep-2006 11:14

NineRays

Total Posts:0

Joined:4/4/2025

You can refer to the node's index and use column's field name:

[VB.Net]
Dim cellValue as Object = node(column.FieldName)
or
Dim cellValue as Object = node(\"SomeFieldName\")
or
Dim indexOfColumnInFieldMap = flyGrid.Columns.FieldMapIndexOf(someColumn)
Dim cellValue as Object = node(indexOfColumnInFieldMap)

Link Posted: 22-Sep-2006 08:08

GrannyKlump

Total Posts:0

Joined:4/4/2025

[quote="NineRays"]You can refer to the node's index and use column's field name:

[VB.Net]
Dim cellValue as Object = node(column.FieldName)
or
Dim cellValue as Object = node("SomeFieldName")
or
Dim indexOfColumnInFieldMap = flyGrid.Columns.FieldMapIndexOf(someColumn)
Dim cellValue as Object = node(indexOfColumnInFieldMap)

ok, getting close but not exactly what i am looking for. I have several text boxes in which i need to populate with data from the grid. if i used the above code i would have to ahve 2 lines of code for everytext box i need to populate. is there another way that would require less code?

something like

userloginlbl.text = node("SomeFieldName")

is that possible?

thanks for all your help!!!

Link Posted: 22-Sep-2006 09:16

NineRays

Total Posts:0

Joined:4/4/2025

something like

userloginlbl.text = node(\"SomeFieldName\")

is that possible?

Yes, that is possible.

Link Posted: 25-Sep-2006 06:30

GrannyKlump

Total Posts:0

Joined:4/4/2025

[quote="NineRays"]

something like

userloginlbl.text = node("SomeFieldName")

is that possible?

Yes, that is possible.

think you can help me out a little here?

I can do this
frmPointofSale.CustomerEmaillbl.Text = node(FlyGrid1.Columns.VisibleColumns(0))

Which works but if we ever add additional columns we have to shuffle the code around to much.

again, thanks for all your help.

GK

Link Posted: 25-Sep-2006 23:34

NineRays

Total Posts:0

Joined:4/4/2025

I can do this
frmPointofSale.CustomerEmaillbl.Text = node(FlyGrid1.Columns.VisibleColumns(0))

Which works but if we ever add additional columns we have to shuffle the code around to much.

This code will works when columns are not movable, if you're using movable columns (which can be moved, hidden, deleted, reordered) it will be better to fetch data from node's cells via column's FieldName.

node(\"SomeFieldName\")

You can initially link controls to columns, for example:

frmPointofSale.CustomerEmaillbl.Tag = FlyGrid1.Columns.VisibleColumns(0)

and later use like as following:

Dim column as Column = frmPointofSale.CustomerEmaillbl.Tag
frmPointofSale.CustomerEmaillbl.Text = node(column)

This code will prevent you from 'movable columns' problem.