How do you get DataGrid.SelectedItem.Text value

[ZmrAbdulla]

I have a datagrid shows list of employees.

SL/No EmpName Extension
..... ....... ..........


I want to click on the "EmpName" to redirect the page to the details of selected employee. The redirecting part is OK for me. But I don't know how to get the selected name value.
What I will use for it?
[tt]
<asp:ButtonColumn>
or
<asp:HyperLinkColumn>[/tt]

I have tried it with <asp:ButtonColumn> and

On SelectedIdex_Change

Dim EmpName As String = CStr(Me.DataGrid1.DataKeys(DataGrid1.SelectedItem.Cells(1).Text)).ToString

and

Dim EmpName As String = CStr(Me.DataGrid1.SelectedItem.Cells(1).ToString)

Both not worked...

any help?


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ca8msm]

There's a few methods you could use. One of these would be to use a CommandField and set the ButtonType property to Link. You can then use the RowCommand method to get the details. e.g.

<asp:CommandField ButtonType="Link" HeaderText="Download" SelectText="Select" ShowSelectButton="true" />

    Protected Sub MyGridView_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles MyGridView.RowCommand
        Select Case e.CommandName
            Case "Select"
                ' Get the relevant parameter that the user selected
                Dim row As GridViewRow = MyGridView.Rows(e.CommandArgument)
                Dim myString As String = MyGridView.DataKeys(row.RowIndex).Value
                
        End Select

    End Sub

Also, remember to set the DataKeyNames property of the GridView to the relevant field that you need to retrieve.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ca8msm]

Oops, sorry I just saw you said DataGrid rather than GridView so you are probably using an older version of the framework. If the above doesn't work, there are alternative methods we can show you.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ZmrAbdulla]

It is DataGrid and working on framework 2
vwd2005 express.
It(datagrid) was fitting correctly to my requirement.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ca8msm]

If you are using version 2.0 of the framework, use the GridView control instead of the DataGrid. It offers the same functionality but is a much improved version of it and then you'll be able to use the method above.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ZmrAbdulla]

Thanks, I will come back if stuck anywhere.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ZmrAbdulla]

I have done it like

  Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim EmpName As String = GridView1.SelectedRow.Cells(1).Text
    End Sub

working fine..

But I am stuck some other part. datagrid had a column for serial number

 <asp:TemplateColumn HeaderText="S/N">
    <ItemTemplate>
    	<span>
    	<%# Container.ItemIndex+1 %>
     	</span>
     </ItemTemplate>
    	<ItemStyle HorizontalAlign="Center" />
     	 <HeaderStyle Width="30px" />
  </asp:TemplateColumn>

that is not supported now. It says code blocks are not allowed inside gridview..
any other way?

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ca8msm]

There's one of two methods I'd usually use.

1) Return the incrementing number as part of the SQL Statement
2) Use the RowDataBound event.

Method #1 should be fairly straight-forward, and #2 would just use an incrementing variable. The value of this variable could then just be assigned to a Label control that you place inside the ItemTemplate.

Let us know if you need an example of either method.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ZmrAbdulla]

Just logged in...
I think No:1 will not work in my case because I am using MS Access at the back end. Let me know if it is possible..

I would apreaciate if you could give an example of the second one.

I also will do a search on the net in the meantime.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ZmrAbdulla]

got an inspiration from

http://forums.asp.net/thread/1205697.aspx

now the code look like

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        rowNum = 0
    End Sub

    Public rowNum As Integer = 0
    Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
        If e.Row.RowType = DataControlRowType.DataRow Then
            Dim gv As GridView = sender
 
            Dim lblRowNum As Label = e.Row.FindControl("RowNum")
            rowNum = rowNum + 1            
            lblRowNum.Text = rowNum
        End If
    End Sub

   <asp:TemplateField HeaderText="S/N">
    <ItemTemplate>
      <asp:Label ID="RowNum" runat="server" />
    </ItemTemplate>
   </asp:TemplateField>

.

It was not working in "GridView1_RowDataBound"

I am not using pages
Thanks again

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ca8msm]

Strange, I'm not sure why the RowDataBound event didn't work as it should in theory. Anyway, glad you got it working.

For the SQL query, I don't really use Access if I can help it so I'm not sure if there is an easy way of returning row numbers or not. Google suggests there isn't, but I did come across this article:

http://databases.aspfaq.com/database/how-do-i-return-row-numbers-with-my-query.html

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ZmrAbdulla]

People do rownumbering in Access SQL (complicated). I prefer to keep my SQL very straight.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.