ASP.NET

datagrid hyperlink

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2007

Posts: 3

Reputation: crprajan is an unknown quantity at this point

Solved Threads: 0

crprajan

Offline

Newbie Poster

datagrid hyperlink

Apr 23rd, 2007

I have a datagrid in my webform with two columns namely empno and empname. The column empname is a hyperlink column. When the page loads both the columns are displaying data from the emp table. There are totally 5 records in the emptable. So five rows are getting displayed in the datagrid. Fine. There are other columns in the emptable namely salary and designation which should be displayed in the appropriate textboxes whenever a particular empname(Hyperlink column) for e.g "Ram" which is the second record in the grid is clicked. Similarly if the third record empname(hyperlink column) is clicked the salary details and designation details should be populated in the appropriate textboxes. How to achieve this? Pls help me with full coding. I am using vb.net

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: datagrid hyperlink

Apr 23rd, 2007

We need to see your code to be more helpful. But basically you need an event handler for the datagrids ItemCommand event. Use the DataGridItemEventArgs object that is passed as a parameter to the handler to determine which link was clicked and the empno it represents, query the database and populate the textboxes.

==========================================
Yadda yadda yadda...
Web junky, fevered monkey

•

Join Date: Oct 2006

Posts: 216

Reputation: jamello is an unknown quantity at this point

Solved Threads: 6

jamello

Offline

Posting Whiz in Training

Re: datagrid hyperlink

Apr 27th, 2007

You need to do several things. This basically a break down of what Hollystyles suggested. Please pay close attention.
edit the html code and edit the Itemcommand property(add a command name)
[html]
<P><asp:datagrid id="dgFS" runat="server" Height="132px" Width="436px" CssClass="DefaultDataGridStyle"
OnItemCommand="Grid_EmpCommand" BorderWidth="0px" CellPadding="0" AutoGenerateColumns="False">
<AlternatingItemStyle BackColor="#d7dce8"></AlternatingItemStyle>
<Columns>
<asp:BoundColumn DataField="empNo" HeaderText="Emp No">
<HeaderStyle Font-Size="15px" Width="100px" Height="45px" BackColor="#6b83c6"></HeaderStyle>
<ItemStyle Font-Size="15px" Height="50px"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="empname" HeaderText="Emp name">
<HeaderStyle Font-Size="15px" Width="100px" Height="45px" BackColor="#6b83c6"></HeaderStyle>
<ItemStyle Font-Size="15px" Height="50px"></ItemStyle>
</asp:BoundColumn>
<asp:ButtonColumn DataTextField="empname" ButtonType="LinkButton" HeaderText="empname" CommandName="updateTextBoxes">
<HeaderStyle Font-Size="15px" Font-Bold="True" Width="100px" Height="50px" BackColor="#6b83c6"></HeaderStyle>
<ItemStyle Font-Size="15px" Height="50px" BorderStyle="Groove" BorderWidth="9"></ItemStyle>
</asp:ButtonColumn>
</Columns>
</asp:datagrid></

[/html]

This summarizes what you already have now just add the OnItemCommand="Grid_EmpCommand" to the datagrid and the
CommandName="updateTextBoxes" to the linkbutton. Open the code screen and add the following

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
 
Sub Grid_EmpCommand(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
' e.Item is the table row where the command is raised.
' For bound columns, the value is stored in the Text property of the TableCell.
Dim empNoCell As TableCell = e.Item.Cells(1)
Dim empnameCell As TableCell = e.Item.Cells(2)
 
Dim empNo As String = empNoCell.Text
Dim empName As String = empnameCell.Text
 
'Assign to the text boxes
If CType(e.CommandSource, LinkButton).CommandName = "updateTextBoxes" Then
textbox1.text = sEmpno
textbox2.text = sEmpname
 
 
 
Sub Grid_EmpCommand(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
' e.Item is the table row where the command is raised.
' For bound columns, the value is stored in the Text property of the TableCell.
Dim empNoCell As TableCell = e.Item.Cells(1)
Dim empnameCell As TableCell = e.Item.Cells(2)
 
Dim empNo As String = empNoCell.Text
Dim empName As String = empnameCell.Text
 
'Assign to the text boxes
If CType(e.CommandSource, LinkButton).CommandName = "updateTextBoxes" Then
textbox1.text = sEmpno
textbox2.text = sEmpname

This should work. Please get back to me

•

Originally Posted by crprajan

I have a datagrid in my webform with two columns namely empno and empname. The column empname is a hyperlink column. When the page loads both the columns are displaying data from the emp table. There are totally 5 records in the emptable. So five rows are getting displayed in the datagrid. Fine. There are other columns in the emptable namely salary and designation which should be displayed in the appropriate textboxes whenever a particular empname(Hyperlink column) for e.g "Ram" which is the second record in the grid is clicked. Similarly if the third record empname(hyperlink column) is clicked the salary details and designation details should be populated in the appropriate textboxes. How to achieve this? Pls help me with full coding. I am using vb.net

Last edited by jamello; Apr 27th, 2007 at 9:31 am.