Can I access one cell to get column,,

[Anoop]

I want to click on one cell in the grid view to get a whole column on another form related to one single cell,,

 

For example:

 

If I had a database which have products table and product details table,,

In my grid view I want to click on one product (cell) to get the details for that  product in separate form which contains another grid view.
the details will be column in another table in the database. 

 

Thanks in advance,,

[Richard Slade]

Hello Anoop,

There are several ways to get the cell value when you click on it which are demonstrated below

private void radGridView1_CellClick(object sender, GridViewCellEventArgs e)
{
    if (e.Row.Index > -1)
    {
        var cellValue = e.Value;
        // or
        var cellValue1 = this.radGridView1.CurrentCell.Value;
        // or
        var cellValue2 = e.Row.Cells["ColumnName"].Value;
    }
}

However, from you explanation of having a product and product details table, you may want to explore using a Hierarchy Grid View to display the data in a hierarcical way. You can find out more about this type of view here

Hope that helps
Richard

[Anoop]

Thanks a lot for your reply,,

one more question,,
can I get a row instead of column,,


thanks

[Richard Slade]

Hello Anoop,

As per my post above, you need to use the GridViewCellEventArgs not System.EventAergs

private void radGridView1_CellClick(object sender, GridViewCellEventArgs e)

This will give you all the row, column and cell information that you will need.
Hope that helps but let me know if you need further information
Richard

[Anoop]

thaaaaaaaaanks Richard

[Richard Slade]

No problem. Please remember to mark as answer and if you need more help, just let me know
Richard