«

I have a gridview which is being populated with no problems.

I want to be able to reference the data from the cells in the row but
having followed an example on MSDN cannot get any data to be displayed
in a text box no matter which cell index I provide.

I tried a row of code that successfully displays the rowindex of the
selected row.

The code with comments is below:

protected void GridView1_SelectedIndexChanged(object sender,
EventArgs e)
{
// Get the currently selected row using the SelectedRow
property.
GridViewRow row = GridView1.SelectedRow;

//This row doesn't put anything in the text box (code copied
from MSDN)
TextBox2.Text = row.Cells[2].Text;

//This row (when not commented out and line above commented
out) puts the row index in the text box
//TextBox2.Text = GridView1.SelectedRow.RowIndex.ToString();
}

Can anyone provide me with the code that will allow me to access the
data in each cell. When working in the debugger I'm being told that
the text value is an empty string which can't be correct coz i can see
the value in the grid. I'm new to both ASP.Net & C# so may be doing
something obviously wrong!

Thanks

"Neil" <> wrote in message
news: oups.com...
>I have a gridview which is being populated with no problems.
>
> I want to be able to reference the data from the cells in the row but
> having followed an example on MSDN cannot get any data to be displayed
> in a text box no matter which cell index I provide.
>
> I tried a row of code that successfully displays the rowindex of the
> selected row.
>
> The code with comments is below:
>
> protected void GridView1_SelectedIndexChanged(object sender,
> EventArgs e)
> {
> // Get the currently selected row using the SelectedRow
> property.
> GridViewRow row = GridView1.SelectedRow;
>
> //This row doesn't put anything in the text box (code copied
> from MSDN)
> TextBox2.Text = row.Cells[2].Text;
>
> //This row (when not commented out and line above commented
> out) puts the row index in the text box
> //TextBox2.Text = GridView1.SelectedRow.RowIndex.ToString();
> }
>
> Can anyone provide me with the code that will allow me to access the
> data in each cell. When working in the debugger I'm being told that
> the text value is an empty string which can't be correct coz i can see
> the value in the grid. I'm new to both ASP.Net & C# so may be doing
> something obviously wrong!
>
> Thanks
>

This works for me:

//////////////////////////////////////////////////////////////
//Use this method to copy the items in the GridViewRowCollection
object
//into the specified System.Array object, starting at the specified
index.
//The System.Array object can then be used to access the items in
the collection.

// Copy the items in the Rows collection into an array.
GridViewRow[] rowArray = new GridViewRow[gv.Rows.Count];
gv.Rows.CopyTo(rowArray, 0);

// Iterate though the array and display the value in the first cell
of the row.
int j = -1;
foreach (GridViewRow row in rowArray)
{
j++;
if (j == idx)
{
Label1.Text = row.Cells[1].Text;
}
}
//////////////////////////////////////////////////////////////



Apparantly the key is to copy the rows into an array to be able to iterate
through it.
I got the basic idea from :
http://msdn2.microsoft.com/en-us/lib...ollection.aspx
-Fred

Hi Fred,

Thanks for the reply.
I used your example but still can't get anything to display.
I'm stumped

The code I used was:

// Copy the items in the Rows collection into an array.
GridViewRow[] rowArray = new GridViewRow[GridView1.Rows.Count];
GridView1.Rows.CopyTo(rowArray, 0);

// Iterate though the array and display the value in the sixth
cell of the row.
int j = -1;
foreach (GridViewRow row in rowArray)
{
j++;
if (j ==GridView1.SelectedRow.RowIndex)
{
TextBox2.Text = row.Cells[5].Text;
}
}

"Neil" <> wrote in message
news: oups.com...
> Hi Fred,
>
> Thanks for the reply.
> I used your example but still can't get anything to display.
> I'm stumped
>
> The code I used was:
>
> // Copy the items in the Rows collection into an array.
> GridViewRow[] rowArray = new GridViewRow[GridView1.Rows.Count];
> GridView1.Rows.CopyTo(rowArray, 0);
>
> // Iterate though the array and display the value in the sixth
> cell of the row.
> int j = -1;
> foreach (GridViewRow row in rowArray)
> {
> j++;
> if (j ==GridView1.SelectedRow.RowIndex)
> {
> TextBox2.Text = row.Cells[5].Text;
> }
> }
>

This works on my page, displaying a specific cell of the selected row:
Label4.Text = Convert.ToString(GridView3.SelectedRow.Cells[1].Text); // Food
item desc

If that doesn't help, I can send you my complete app and you can work back
from there.

-Fred

Still can't get it to work.

I don't understand this at all. The code looks fine, the grid has data
in it and if I use this line:
TextBox2.Text = GridView1.SelectedRow.RowIndex.ToString();

I get a value displayed in the text box which indicates to me that the
code is seeing a row (at least) in the grid.

I'd be grateful for a copy of your app as I'm tearing my hair out here
trying to solve what should be a trivial matter.

[SueL]

Fred,

I am having the same problem as Neil.

Could I also have a copy of your app?

- many thanks in advance

Sue

[chookieeee]

after taking a good 2.4 hours of my day,
i worked it out... altho i dont know why this works...

string s = GridView1.SelectedRow.Cells[2].Text;

the '2' seems to give me my first column... i have no idea why.

ow well. it works. have fun.

[Moim]

I guess, the best thing to do this is as follows

For example if you have a row where the first column is a link button into the item template then your approach should be

Control ctl = row.Controls[0];// get the first control reference
string value = ((System.Web.UI.WebControls.LinkButton)(ctl.Contro ls[1])).Text; // if the control you defined in Item template mark up is a link button;
// otherwise you need to do the appropriate casting

[m6azeez]

Originally Posted by chookieeee

after taking a good 2.4 hours of my day,
i worked it out... altho i dont know why this works...

string s = GridView1.SelectedRow.Cells[2].Text;

the '2' seems to give me my first column... i have no idea why.

ow well. it works. have fun.

you are the best

thanks a lot dude I like your simple and correct way of solving this issue
it works perfectly

thanks again

[andyv]

a way round this problem is to get the keydata from the gridview:

inside the gridview tag include the field you want to access in this field:

<asp:GridView ID="grdCalls" runat="server" DataKeyNames="FolderID, FolderName">

then in the event method:

grdCalls_SelectedIndexChanged(object sender, EventArgs e)
{
string FolderID = grdCalls.SelectedDataKey[0].ToString()

}

should do the trick nicely