How to access column of a grid by its bound field?

[Abdul Majid]

How can I access a column of a bound grid by the field?

If I have bound a grid by a table "Projects", and I want to read the data of ProjectId or any other column by Field name; upon double click event of the row; then I should be able to read the data of that column.

Somthing like that

syncFindGrid.Columns("ProjectId").text
syncFindGrid.Columns("LocationId").text
etc

I don''t want to use (Colindex,Rowindex).text methos because I am not sure of the index of the columns, since I am filling it for different fomrs with different tables.

[Administrator]

Hi Abdul, To access a column value based on its fieldname or column name, make use of the NameToColIndex property of the grid. Inserting the following code in the CellDoubleClick Event of the grid achieves the same. int colInd = this.gridDataBoundGrid1.Binder.NameToColIndex("Col1"); // specify the column name here MessageBox.Show(this.gridDataBoundGrid1.Model[e.RowIndex,colInd].CellValue.ToString()); On double clicking any row you can view that particular column value. Please refer the sample attached for demonstration of these functionalities. Thanks, Rajagopal

ColAccessSample.zip