How to pass parameter from Datagrid selected row to a text box

Ed Dror · Jul 11, 2007

Hi there,

I'm using Visual studio 2005 pro and I want to pass parameter from datagrid selected cell to textbox

I have Select button in my datagrid

I wrote this

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
Try
If e.Row.RowType = DataControlRowType.DataRow Then
Me.txtSubTypeID.Text = e.Row.Cells(1).Text
Me.txtBSP.Text = e.Row.Cells(8).Text
Me.txtALC_ID.Text = e.Row.Cells(3).Text
End If
Catch ex As Exception
ErrorMessage.Text = ex.Message.ToString
End Try
End Sub

But it always it show the last record nothing change when I'm using the SELECT button?

I tryied all other methods but e.Row working only with RowDataBound

How do I do that?

Thanks,

Ed Dror

(e-mail address removed)

Walter Wang [MSFT] · Jul 12, 2007

Hi Ed,

The RowDataBound event is fired for every row when it's bound to the data,
the last time it's called is when the last row is bound, that's why you
always see the last row's data.

Instead, you need to use the SelectedIndexChanged event to get the selected
row's data. Here's a demo:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub grid1_SelectedIndexChanged(ByVal sender As Object, ByVal
e As System.EventArgs)
Response.Write(grid1.SelectedItem.Cells(1).Text)
End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp

ataGrid ID="grid1" runat="server" DataSourceID="SqlDataSource1"
CellPadding="4" ForeColor="#333333" GridLines="None"
OnSelectedIndexChanged="grid1_SelectedIndexChanged">
<Columns>
<asp:ButtonColumn Text="Select"
CommandName="Select"></asp:ButtonColumn>
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"
/>
<EditItemStyle BackColor="#2461BF" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True"
ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White"
HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#EFF3FB" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"
/>
</asp

ataGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings

ubsConnectionString %>"
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone],
[address] FROM [authors]">
</asp:SqlDataSource>
</form>
</body>
</html>

Hope this helps.

Regards,
Walter Wang ([email protected], remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Ed Dror · Jul 12, 2007

Hi there,

when I'm run this page I'm geting error that says:

'SelectedItem' is not a member of 'System.Web.UI.WebControls.GridView'

there is no SelectedItem for Gridview

Thanks,
Ed Dror

Walter Wang [MSFT] · Jul 13, 2007

Hi Ed,

Since your post title mentioned "Datagrid", I thought you're using DataGrid
instead of GridView. (DataGrid is a server control existed in ASP.NET 1.1
and can be used in 2.0 too)

For GridView, you need to use GridView.SelectedRow.Cells.

Hope this helps.

Regards,
Walter Wang ([email protected], remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Ed Dror · Jul 17, 2007

Walter,
It works!

Thanks again
Ed Dror

how to count number of unchecked checkboxes in a gridview?	5	May 25, 2009
GridView inside a FormView	4	Dec 31, 2009
how to get field value of selected row in gridview?	3	May 21, 2009
conditional formatting of text in a gridview	6	Dec 8, 2008
add a second row to footer of gridview	1	Feb 9, 2006
add Another row to GridView Footer-	1	Feb 9, 2006
How to get gridview selected row text	1	Aug 7, 2007
Remove Control from Gridview Row	6	Oct 16, 2006

How to pass parameter from Datagrid selected row to a text box

Ed Dror

Walter Wang [MSFT]

Ed Dror

Walter Wang [MSFT]

Ed Dror

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads