How to add link buton in gridview and to make it to work

Question

subhankar02dey 0 Light Poster

14 Years Ago

I have a gridview in which i populate data about books in a library.
There is a column as 'Book Name' in the gridview.
I want to make this column as linkbutton.
And whenever I will click the linkbuttons, the details of the corresponding book will be displayed in another page.
How can I do this.
Pls help.

asp.net

5 Contributors
7 Replies
3K Views
3 Weeks Discussion Span
Latest Post 14 Years Ago Latest Post by siju kuriakose

mohammed yaghi 0 Newbie Poster

14 Years Ago

hi subhankar02dey , download http://hotfile.com/dl/67535648/2c4215c/WebSite6.rar.html
prepare using visual studio 2010
Solving exactly what u want
thanks

Edited 14 Years Ago by mohammed yaghi because: n/a

rohand 1 Posting Whiz in Training

14 Years Ago

You can define TemplateField -> ItemTemplate -> define <asp:HyperLink> in your GridView.

<asp:TemplateField HeaderText="Click">                
  <ItemTemplate>
       <asp:HyperLink ID="link1" runat="server" ></asp:HyperLink>
  </ItemTemplate>
</asp:TemplateField>

Now you just need to handle RawDataBound Event of GridView. In the event, you just need to find the hyperlink column by it's ID like below :

DataRowView rowView = (DataRowView)e.Row.DataItem;
Hyperlink hLink = e.Row.FindControl("id of hyperlink");
hLink.Text = rowView["book_name"].ToString();
hLink.NavigateURL = "test.aspx?bookid=" + rowView["book_id"].ToString();

Now on the test.aspx page, just retrieve query string and pass it in select query to pull all the data related to particular book by id.

hope it will help you :-)

I have a gridview in which i populate data about books in a library.
There is a column as 'Book Name' in the gridview.
I want to make this column as linkbutton.
And whenever I will click the linkbuttons, the details of the corresponding book will be displayed in another page.
How can I do this.
Pls help.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

subhankar02dey 0 Light Poster · Answer 1 · 2010-09-27T01:44:56+00:00

Ok, but the problem is I am populating data to a dynamic gridview, so I need to set generateautocolumns=true.

The aspx code is

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" 
            
            EmptyDataText="There are no data records to display." 
            onrowdatabound="GridView1_RowDataBound" >
            <Columns>
            
                <asp:CommandField ShowEditButton="True" />
                <asp:TemplateField HeaderText="bid" SortExpression="bid">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("book_id") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("book_id") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="bname" SortExpression="bname">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("book_name") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("book_name") %>' 
                            Visible="False"></asp:Label>
                        <asp:LinkButton ID="l1" runat="server" PostBackUrl="~/codes.aspx"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>

And in my .cs file, 

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState == DataControlRowState.Alternate || e.Row.RowState == DataControlRowState.Normal))
        {
            LinkButton l1 = (LinkButton)e.Row.FindControl("l1");
            Label bname = (Label)e.Row.FindControl("Label1");
            Label bid = (Label)e.Row.FindControl("Label2");

            l1.Text = bname.Text;
            l1.PostBackUrl = "~/codes.aspx?bid=" + bid.Text;


        }
    }

Now, the problem is the gridview shows book_id, book_name(Hyperlinked) and then again the whole data(book_id, book_name,book_author,book_price etc) as coming from database as the autogeneratecolumn is set true. I cant set it false as I need to make the gridview dynamic.
And also, I cannot make the autogenerated book_id and book_name column invisible by writing Gridview1.columns[3].visible=false; Because, column 3 is not been recognised as I made just two columns in <columns> tag.
What to do?
I need to set those second book_id and book_name column invisible. Pls help.

rohand 1 Posting Whiz in Training · Answer 2 · 2010-09-27T12:52:49+00:00

Set AutoGenerateColumns = False. Then in your Select Query just pull BookID and BookName column as you are displaying only bookid and bookname column...

Ok, but the problem is I am populating data to a dynamic gridview, so I need to set generateautocolumns=true.

The aspx code is

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" 

            EmptyDataText="There are no data records to display." 
            onrowdatabound="GridView1_RowDataBound" >
            <Columns>

                <asp:CommandField ShowEditButton="True" />
                <asp:TemplateField HeaderText="bid" SortExpression="bid">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("book_id") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("book_id") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="bname" SortExpression="bname">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("book_name") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("book_name") %>' 
                            Visible="False"></asp:Label>
                        <asp:LinkButton ID="l1" runat="server" PostBackUrl="~/codes.aspx"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>

And in my .cs file,

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState == DataControlRowState.Alternate || e.Row.RowState == DataControlRowState.Normal))
        {
            LinkButton l1 = (LinkButton)e.Row.FindControl("l1");
            Label bname = (Label)e.Row.FindControl("Label1");
            Label bid = (Label)e.Row.FindControl("Label2");

            l1.Text = bname.Text;
            l1.PostBackUrl = "~/codes.aspx?bid=" + bid.Text;


        }
    }

Now, the problem is the gridview shows book_id, book_name(Hyperlinked) and then again the whole data(book_id, book_name,book_author,book_price etc) as coming from database as the autogeneratecolumn is set true. I cant set it false as I need to make the gridview dynamic.
And also, I cannot make the autogenerated book_id and book_name column invisible by writing Gridview1.columns[3].visible=false; Because, column 3 is not been recognised as I made just two columns in <columns> tag.
What to do?
I need to set those second book_id and book_name column invisible. Pls help.

subhankar02dey 0 Light Poster · Answer 3 · 2010-09-28T00:19:18+00:00

i cant Set AutoGenerateColumns = False as my gridview is not to be made static.
The same gridview is used to fetch other data coming from other queries as well , so I cant Set AutoGenerateColumns = False
I mentioned also before about it
What to do to solve it without Setting AutoGenerateColumns = False
pls help

guru_sarkar 0 Junior Poster in Training · Answer 4 · 2010-09-28T00:54:50+00:00

In that case I have to options for you:
1: Show Select Button and let user click that instead of your bookname. Then in the GV SelectedIndexChanged event, you can redirect the user to the page of your choice and pass appropriate bookid as querystring parameter.
2: You extend the GV to make entire row clickable like shown here:
http://www.mostlydevelopers.com/mostlydevelopers/blog/post/2008/06/02/Row-Clickable-GridView.aspx

siju kuriakose · Answer 5 · 2010-09-28T15:34:30+00:00

Hi ,

Pls add a hyperlink to your gridview and bind the ID like this..

<asp:HyperLink runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"BookName")%>' NavigateUrl='<%# "~/BookView.aspx?id=" + DataBinder.Eval(Container.DataItem,"BookID")%>' ID="Hyperlink1" />.

hope your reply