[Resolved] GridView TemplateField

snufse · #1 (**permalink**) July 28th, 2008, 08:36 AM

I have a GridView and have converted a BoundField into a TemplateField.

In my GridView I have 2 text fields, one short and a one long. When I load the GridView I show the short text field as a LinkButton and the long text field as an invisible TeplAteField. When I click on the LinkButton I need to retrieve the long text.

This is the markup code being created:

:):)

Code:

<asp:TemplateField HeaderText="Notes1" Visible="False">
                       <EditItemTemplate>
                           <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("item_notes1") %>'></asp:TextBox>
                       </EditItemTemplate>
                       <ItemTemplate>
                           <asp:Label ID="Label1" runat="server" Text='<%# Bind("item_notes1") %>'></asp:Label>
                       </ItemTemplate>
                   </asp:TemplateField>

Here is my code for the click on the linkbutton, need the code to retrieve the TemplateField value. My code does not work

Code:

Protected Sub GridView2_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView2.RowCommand

If e.CommandName = "notes" Then

Dim index As Integer = Convert.ToInt32(e.CommandArgument)
            Dim mySelectedRow As GridViewRow = GridView2.Rows(index)
            Dim mySelectedCell As TableCell

            mySelectedCell = mySelectedRow.Cells(6)
            Dim MyText As String = mySelectedCell.Text

:):):)

alliancejhall · #2 (**permalink**) July 28th, 2008, 08:42 AM

do something like:

Dim index As Integer = Convert.ToInt32(e.CommandArgument)
Dim mySelectedRow As GridViewRow = GridView2.Rows(index)

mySelectedCell = mySelectedRow.FindControl("Label1")

Dim MyText As String = CType(mySelectedCell, TextBox).Text

Jason Hall

snufse · #3 (**permalink**) July 28th, 2008, 09:16 AM

Jason, thank you. Get some errors:

mySelectedCell = mySelectedRow.FindControl("Label1")
RuntimeError:
Unable to cast object of type 'System.Web.UI.WebControls.Label' to type 'System.Web.UI.WebControls.TableCell'.

Syntax error:
mySelectedCell = mySelectedRow.FindControl("Label1")
Value of type "System.Web.UI.Webcontrol.TableCell" cannot be converted to "System.Web.Ui.Webcontrol.Textbox'

alliancejhall · #4 (**permalink**) July 28th, 2008, 09:19 AM

sorry my fault:

Try this

Dim index As Integer = Convert.ToInt32(e.CommandArgument)
Dim mySelectedRow As GridViewRow = GridView2.Rows(index)
Dim MyText As String = CType(mySelectedRow.FindControl("Label1"), TextBox).Text

Jason Hall

snufse · #5 (**permalink**) July 28th, 2008, 10:42 AM

Jason, see below, thank you.

Dim MyText As String = CType(mySelectedRow.FindControl("Label1"), TextBox).Text

Get error:
Unable to cast object of type 'System.Web.UI.WebControls.Label' to type 'System.Web.UI.WebControls.TextBox'.

alliancejhall · #6 (**permalink**) July 28th, 2008, 10:44 AM

I'm having a brain fart kinda day. change where it says textbox to label because the control you
are pulling the text from is a label

Dim MyText As String = CType(mySelectedRow.FindControl("Label1"), Label).Text

Jason Hall

snufse · #7 (**permalink**) July 28th, 2008, 11:24 AM

Jason, that worked super, thank you. That saves me an extra trip to a table to get the info. Now, is it possible to show the text in a tooltip when I click on cell 5 (which is a link button) and have text in cell 6 show in the tool tip? Can you share some ideas here please?

alliancejhall · #8 (**permalink**) July 28th, 2008, 11:30 AM

you do it very similarly

CType(mySelectedRow.FindControl("LinkButton1"), LinkButton).ToolTip = MyText

how ever if you want it to always be the hidden text with out even selecting the row. You would set
that in your aspx page

something like

<asp:TemplateField HeaderText="Link">
     <ItemTemplate>
         <asp:Label ID="LinkButton1" runat="server" Text="Click Here" ToolTip='<%# Eval("item_notes1") %>'></asp:Label>
     </ItemTemplate>
</asp:TemplateField>

basically you can use the bound data from your data source in all of your template fields?

I think this is what you mean right.

Jason Hall

alliancejhall · #9 (**permalink**) July 28th, 2008, 11:32 AM

sorry i just copied with out fixing everything:

<asp:TemplateField HeaderText="Link">
     <ItemTemplate>
         <asp:LinkButton ID="LinkButton1" runat="server" Text="Click Here" ToolTip='<%# Eval("item_notes1") %>'></asp:LinkButton>
     </ItemTemplate>
</asp:TemplateField>

Jason Hall

snufse · #10 (**permalink**) July 28th, 2008, 12:14 PM

Here is what I have:

GridView with 6 columns:
Column 1 = Date (BoundFiled)
Column 2 = Job Number (Boundfield)
Column 3 = Quantity (BoundField)
Column 4 = Cost Center (Boundfield)
Column 5 = Short Text - 20 chararacters (LinkButton)
Column 6 = Long Text - 200 characters (hidden TemplateField)

The idea was to click on column 5 and then show the lon text from column 6 in a ListBox pop up. This works now fine (with the code you gave me !!). The problem is that ListBox does not wrap.

So what I was thinking was to do "mouse over" or "click" on cell 5 and show the long text in tool tip from cloumn 6. This is the code snippet I am looking for. (Do I need to change column 5 back to a boundfield?) Thank you.

Need to download code?

Navigation