delete rows from gridview control?

Question

0.00/5 (No votes)

See more:

Dear All,

delete from gridview rows:

code:

C#

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("delete from savetable where productid=@productid", con);
                cmd.Parameters.AddWithValue("@productid", Session["ID"].ToString());
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                GridView1.DataSource = ds;
                GridView1.DataBind();
                con.Close();
            }
        }
        catch
        {
        }      
    }

here row not deleted, what mistake here please reply me

Posted 4-Mar-14 18:49pm

member1431

Updated 4-Mar-14 19:16pm

Tom Marvolo Riddle

v2

Add a Solution

Comments

Ramug10 5-Mar-14 0:56am

you need to write delete code in grid view row command event.

member1431 5-Mar-14 1:04am

yes

Tom Marvolo Riddle 5-Mar-14 1:23am

solution posted .Try it and let me know

Tom Marvolo Riddle 5-Mar-14 0:58am

get the ID and pass it

member1431 5-Mar-14 1:26am

row not deleted and am trying

Tom Marvolo Riddle 5-Mar-14 1:27am

did you try my solution?

member1431 5-Mar-14 1:33am

ya here savetable is temporary table

columns is:id, userid, productid,quantity

change and trying your code also but is not coming

Tom Marvolo Riddle 5-Mar-14 1:38am

posted solution is a working code.I usually do like this

1.Bind gridview along with productid
2.In rowcommand get the product id
3.pass the id and delete it.

use debugger in rowcommand and find whether you are getting id or not

member1431 5-Mar-14 2:24am

Dear jas,

this code please check:

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
ds = new DataSet();
var Productid = ds.Tables[0].Rows[0]["Productid"].ToString();

SqlConnection con = new SqlConnection();
con.ConnectionString = ("Data Source=.; initial catalog=masthan; user id=sa; pwd=123;");
con.Open();
//SqlCommand cmd = new SqlCommand("DELETE FROM savetable WHERE Productid=@Productid", con);
string qry = "DELETE FROM savetable WHERE Productid=@Productid";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.ExecuteScalar();
con.Close();
}
here got small error means cannot find table 0
please reply me

Tom Marvolo Riddle 5-Mar-14 2:27am

place breakpoint at
var Productid = ds.Tables[0].Rows[0]["Productid"].ToString();

this line and check whether it has product id or not

member1431 5-Mar-14 1:41am

wait i will try this steps after that i will message you just wait please

Tom Marvolo Riddle 5-Mar-14 1:42am

ok

1 solution

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 · Answer 1 · 2014-03-04T19:08:00

Try this:

Markup:

ASP.NET

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
     AutoGenerateColumns="False" CellPadding="3"
     onpageindexchanging="GridView1_PageIndexChanging"
     onrowcommand="GridView1_RowCommand" onrowdeleting="GridView1_RowDeleting">
     <RowStyle ForeColor="#000066" />
     <Columns>

     <asp:TemplateField HeaderText="product id" Visible="False">
         <ItemTemplate>
             <asp:Label ID="label1" runat="server" Text='<%#Eval("productid")%>'></asp:Label>
         </ItemTemplate>
         </asp:TemplateField>

<asp:TemplateField HeaderText="Delete">
         <ItemTemplate>
         <asp:ImageButton ID="ImageButton1" runat="server"
          ImageUrl ="../image/delete.png" CommandName ="Delete" />
         </ItemTemplate>
         </asp:TemplateField>

       </Columns>
     <FooterStyle BackColor="White" ForeColor="#000066" />
     <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
     <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
     <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White"
         Height="50px" />
 </asp:GridView>

In RowCommand Event:

C#

 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
     
 if (e.CommandName == "Delete")
            {
                ImageButton img = (ImageButton)e.CommandSource as ImageButton;
                GridViewRow row = img.NamingContainer as GridViewRow;

                Label lbid = (Label)row.FindControl("label1");
                int productid = Convert.ToInt32(lbid.Text);


                 // pass the product id and perform delete process

            }
}