Accessing GridView Cells Value

Question

I am trying to access the integer value of the first cell but I'm getting this error:

Unable to cast object of type 'System.Web.UI.WebControls.DataControlFieldCell' to type 'System.IConvertible'.

And the value i have stored in that cell is an ID like 810

My Code

int myID = Convert.ToInt32(GridView1.Rows[rowIndex].Cells[0]);

score 5 · Accepted Answer · answered Sep 23 '11 at 20:16

5

Cells[0] returns a DataControlFieldCell object, not the cell's value.
Use the cell's Text property.

answered Sep 23 '11 at 20:16

SLaks

837,282
173
1,862
1,933

Ok, that does not help me, what should I use?.. I am new to C#. Thanks – user710502 Sep 23 '11 at 20:17
3

`Convert.ToInt32(GridView1.Rows[rowIndex].Cells[0].Text)` – SLaks Sep 23 '11 at 20:19
Thank you, appreciate the help – user710502 Sep 23 '11 at 20:22
The value is comming in as blank not sure why it cant find the value its comming as a "" – user710502 Sep 23 '11 at 20:31
@user710502 - I guess the first column of GridView contains linkbutton or something. – KV Prajapati Sep 24 '11 at 01:57

score 4 · Answer 2 · edited Nov 07 '12 at 15:25

4

GridView1.Rows[rowIndex].Cells[0].Text

--or--

GridView1.Rows[rowIndex].Cells[0].Value

Makes programmer's life harder with these stupid ambiguities introduced by Microsoft over time.

edited Nov 07 '12 at 15:25

Alexander

2,300
2
25
33

answered Nov 07 '12 at 15:01

Bhaggya

41
1
1

score 0 · Answer 3 · answered Sep 19 '14 at 08:53

0

Try this both of this codes are valued

 int SB = Convert.ToInt32(gdTest.SelectedRow.Cells[1].Text);

              ---------OR-------

int AS = Convert.ToInt32(gdTest.Rows[1].Cells[1].Text);

answered Sep 19 '14 at 08:53

tharinda

9
6

score 0 · Answer 4 · answered Jun 20 '18 at 11:44

The recommended approach to retrieve the value of a cell in GridView/FormView is to use ExtractValuesFromCell() method. See an example below:

foreach(var row in GridView.Rows) 
{
    // retrieve all cell values in a row as a ordered dictionary.
    IOrderedDictionary cellValues = new OrderedDictionary();
    foreach(DataControlFieldCell cell in row.Cells)
    {      
            cell.ContainingField.ExtractValuesFromCell(cellValues, cell, row.RowState, true);
    }

    // now do something with the cellValues for e.g read the columns value
    // like - cellValues["EmployeeName"]
}

The returned values are strings and can be converted with the help of System.Convert class.

To elaborate, this way gives the old values stored when the gridview is originally binded/created, but not the new value typed into the input box when you are updating — Bbb, Jul 13 '18 at 14:33

Accessing GridView Cells Value

4 Answers4

Linked

Related