2

how to get cell value from gridview without using cell index? Let say the first column name in my table is "RowNumber".

instead of using

string name = GridView1.Rows[0].Cells[0].Text;

Something like

string name = GridView1.Rows[0].Cells["RowNumber"].Text;
Adrian
  • 836
  • 7
  • 20
  • 44
  • Please refer http://stackoverflow.com/questions/9715983/how-to-get-the-cell-value-by-column-name-not-by-index-in-gridview-in-asp-net – Sain Pradeep Oct 21 '13 at 13:49
  • Possible duplicate of [How to get the cell value by column name not by index in GridView in asp.net](https://stackoverflow.com/questions/9715983/how-to-get-the-cell-value-by-column-name-not-by-index-in-gridview-in-asp-net) –  Jul 01 '17 at 14:53

3 Answers3

5

You could cast the GridViewRow's DataItem property into a DataRowView, and then reference the column names:

DataRowView rowView = (DataRowView)GridView1.Rows[0].DataItem;
string name = rowView["RowNumber"].ToString();

You can't do this from the Cells collection, because they are just TableCell objects, and they don't know anything about the underlying data.

The DataItem property represents the values in that row from the underlying datasource, so that's what you want to deal with.

Josh Darnell
  • 11,304
  • 9
  • 38
  • 66
  • @Adrian Around that code, make sure the row you are checking is actually a data row (`if (GridView1.Rows[0].RowType == DataControlRowType.DataRow)`). Row zero is probably a header row, which has no data associated with it (also, FYI - you can't do line breaks in comments here). – Josh Darnell Oct 22 '13 at 15:26
2

You can use datakeys to access any data you want from the row index.

In the markup of the gridview, add all the fields you want to be able to access to the gridview.

<asp:GridView ID="gvTransactionHistory" runat="server" 
    AutoGenerateColumns="false"  
    onselectedindexchanging="gvTransactionHistory_SelectedIndexChanging" 
    DataKeyNames="ID, AnyField">

These datakeys can be accessed in the code behind with the row index

    var id = gvTransactionHistory.DataKeys[rowIndex].Values["ID"];
    var AnyField = gvTransactionHistory.DataKeys[rowIndex].Values["AnyField"];
Smeegs
  • 9,151
  • 5
  • 42
  • 78
0

here is a function I wrote. since we typically get the same list of fields over and over again, I cached the index lookups.

    private static readonly HybridDictionary cache = new HybridDictionary();

    public static object[] GetColumnValues(
        this GridView g, 
        int rownumber, 
        string columnNamesCommaSeparated)
    {
        var dataView = g.DataSource as DataView;
        if (dataView != null)
        {
            DataRow dataRow = dataView[rownumber].Row;
            object[] items = dataRow.ItemArray;
            DataColumnCollection columns = dataRow.Table.Columns;

            string lookupkey = g.ID + columnNamesCommaSeparated;
            var colids = cache[lookupkey] as int[];
            int columnCount;
            if (colids == null)
            {
                string[] columnNames = columnNamesCommaSeparated.Split(',');
                columnCount = columnNames.Count();
                colids = new int[columnCount];

                for (int i = 0; i < columnCount; i++)
                {
                    colids[i] = columns.IndexOf(columnNames[i]);
                }

                cache.Add(lookupkey, colids);
            }
            columnCount = colids.Length;
            var values = new object[columnCount];

            for (int i = 0; i < columnCount; i++)
            {
                values[i] = items[colids[i]] ?? "";
            }
            return values;
        }

        return null;
    }

to use it do something like

            object[] values = g.GetColumnValues(e.Row.DataItemIndex, "Firstname,Lastname,CompanyName");
            if (values != null)
            {
                string header = Server.HtmlEncode(values[0] + " " + values[1] + " @ " + values[2]);
            }
            // do whatever you want with this value
kns98
  • 330
  • 2
  • 7