how to retrieve cell contents

[LEONARD]

I'm using VS2010 and VB for winforms.
The grid is being populated in an unbound mode.
In columns 0 and 1 (which the user cannot see), I have displayed a key value.

If the user clicks on a row, I want to capture the value in column 0 and column 1 and query the database.
The results are then displayed in a form.

Can you please guide me how to capture the values in the columns.
Each time the user clicks on a new row the values change.

Thank you
Leonard

[Stefan]

Hi Leonard,

Thank you for writing.

When the user selects a row, it becomes current. You can access the latter via the CurrentRow property of RadGridView. Then, you can access its cell collection and the cells values. Here is an example:

radGridView1.CurrentRow.Cells(0).Value
//or
radGridView1.CurrentRow.Cells("YourFirstColumnName").Value

More information about accessing cells is available here: http://www.telerik.com/help/winforms/gridview-cells-accessing-cells.html.

I hope that the provided information addresses your question.

Regards,
Stefan
Telerik

 

 

[LEONARD]

Thank you for the information.
2 more questions:

1: If the user clicks in column 2 I want to be able to pop up a new form.
Could you please email how to determine if the click is in column 2?

2: I want to make the back color for column 2 to be yellow.
Could you please email how to display column 2, with a backcolor = yellow.

[Stefan]

Hi Leonard,

Here are the answers to your questions:

1. You can use the CurrentCellChanged event of the control, which will get triggered when the user clicks a cell. In it you can check if the CurrentColumn is the desired one.

2. You can use the CellFormatting event as advised in the other thread of yours.

Here you can find the RadGridView documentation where you can find quick answers to most of your questions: http://www.telerik.com/help/winforms/gridview-overview.html

I hope this helps.

Regards,
Stefan
Telerik