Add View and Delete button to gridview

Question

0.00/5 (No votes)

See more:

I have one gridview in which i bind data through sql command.
aspx page:

<asp:GridView ID="gv_ads" runat="server" >  
</asp:GridView>

aspx.cs:

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridview();
        }
    }
protected void BindGridview()
    {
        var o = Session["advertise"];
        if (o != null)
        {
            ses = o.ToString();
        }

        SqlCommand cmd = new SqlCommand("sps_myads", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@email", ses);
        try
        {
            con.Open();
            gv_ads.EmptyDataText = "No Records Found";
            gv_ads.DataSource = cmd.ExecuteReader();
            gv_ads.DataBind();
            con.Close();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

stored procedure:

SQL

ALTER PROCEDURE [dbo].[sps_myads] 
	@email nvarchar(100)
AS
BEGIN
	select CONVERT(VARCHAR(10),registertime ,104) as Register_On, r.ad_id, c.category_name, sc.subcategory_name, title from dbo.tbl_adregister r INNER JOIN tbl_category c ON r.category = c.category_id INNER JOIN tbl_subcategory sc on r.subcategory = sc.subcategory_id
	where useremail=@email
END

It showing me result according to my query, my problem is i need two buttons for every row at right side of my result: one is View and other is Delete.
View button: when i click on view button it will redirect to other page with "ad_id" as parameter so that i can display complete details of one particular clicked row "ad_id".
Delete button: when i click on delete button of particular row it should ask a confirmation dialog to delete and after click ok it will delete particular row data from gridview.

Please help programmers.

Posted 18-Apr-14 23:29pm

Raj Negi

Add a Solution

3 solutions

Solution 1

this might help you.

http://forums.asp.net/t/1723602.aspx?What+is+Item+Template+[^]

Posted 18-Apr-14 23:31pm

kedar001

Solution 3

Refer:
1. How-to-Update-Delete-Insert-in-GridView-in-csharpnet[^]
2. Walkthrough: Creating Master/Detail Web Pages in Visual Studio[^]

Posted 19-Apr-14 2:46am

Peter Leow

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tom Marvolo Riddle · Accepted Answer · 2014-04-18T23:42:00

Try this:
For View button:

ASP.NET

<asp:templatefield headertext="No Of Seats" xmlns:asp="#unknown">
<itemtemplate>
<asp:linkbutton id="LinkButton1" runat="server"
 postbackurl="<%#Eval("id","Yourpage.aspx?id={0}") %>" forecolor="Red"> 
                                       Go to.</asp:linkbutton> >
</itemtemplate>
</asp:templatefield>

For Delete Button:
Use RowCommand Event

ASP.NET

<asp:templatefield headertext="Delete" xmlns:asp="#unknown">
            <itemtemplate>
            <asp:imagebutton id="ImageButton3" runat="server">
             ImageUrl ="../image/delete.png" CommandName ="Delete" OnClientClick="return confirm("Are you sure you want to delete this entry?");"  />
            
            </asp:imagebutton></itemtemplate>
            </asp:templatefield>

In .cs page:

C#

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
  {
      try
      {

          if (e.CommandName == "Delete")
          {
              ImageButton img = (ImageButton)e.CommandSource as ImageButton;
              GridViewRow row = img.NamingContainer as GridViewRow;

              Label lbid = (Label)row.FindControl("label1");//idlabel
              bid = Convert.ToInt32(lbid.Text);

            // pass the bid to delete

          }



      }
      catch (Exception ex)
      {
          Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Cannot be Deleted because it is used in other Pages!!!');", true);
      }

  }

you can achieve view process in rowcommand also