How to delete a row from this Datatable?

Question

0.00/5 (No votes)

See more:

i have this code and when i click a button i wanna delete the last row of the data table and save that table in a session. how can i do that?? this is my code..

public partial class Myreservations : System.Web.UI.Page
{


    DBAccess isusrobj = new DBAccess();


    protected void Page_Load(object sender, EventArgs e)
    {
        String email = isusrobj.setSessionVar();

        if (email != (String)Session["email"]) 
        {

            HyperLink choosemore = new HyperLink();
            ImageButton cancelDVD = new ImageButton();
            ImageButton BookDVDs = new ImageButton();

            choosemore.ImageUrl = "~/Images/more.gif";
            choosemore.NavigateUrl = "Movies.aspx";

            cancelDVD.ImageUrl = "~/Images/cancel.gif";
            cancelDVD.OnClientClick = cancelDVDs(); //this is where i wanna delete the rows

            BookDVDs.ImageUrl = "~/Images/bookdvds.gif";
            BookDVDs.OnClientClick = BookDVDsinDB();

            Panel1.Controls.Add(choosemore);
            Panel1.Controls.Add(cancelDVD);
            Panel1.Controls.Add(BookDVDs);


            String Mname = Request.QueryString["Vn"];
            String Myear = Request.QueryString["Vy"];
            String Mstars = Request.QueryString["Vs"];


            DataTable bookingtable = (DataTable)Session["table"];
            DataRow row = bookingtable.NewRow();
            row["Movie Name"] = Mname;
            row["Movie Year"] = Myear;
            row["Starring"] = Mstars;

            if (bookingtable.Rows.Count == 0)
            {

                bookingtable.Rows.Add(row);
                bookingtable.AcceptChanges();
                Reservations.DataSource = bookingtable;
                Reservations.DataBind();
                Session.Add("table", bookingtable);



            }
            else
            {
                bookingtable = (DataTable)Session["table"];
                bookingtable.Rows.Add(row);
                bookingtable.AcceptChanges();
                Session.Add("table", bookingtable);
                Reservations.DataSource = bookingtable;
                Reservations.DataBind();
            }



        }
        else
        {
            loginLabel.Text = "You have not logged in.Please log in to book the DVD!";
        }
    }

    private string BookDVDsinDB()
    {
  
        throw new NotImplementedException();
    }

    private string cancelDVDs()
    {

        throw new NotImplementedException();
    }

Posted 25-Aug-11 19:08pm

aroshlakshan

Add a Solution

2 solutions

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)

Prerak Patel · Answer 1 · 2011-08-25T19:14:00

Solution 1

C#

bookingtable = (DataTable)Session["table"];
if(bookingtable.Rows.Count > 0) bookingtable.Rows(bookingtable.Rows.Count - 1).Delete();
bookingtable.AcceptChanges();
Session.Add("table", bookingtable);
Reservations.DataSource = bookingtable;
Reservations.DataBind();

Posted 25-Aug-11 19:14pm

Prerak Patel

Comments

Suresh Suthar 26-Aug-11 1:19am

Nice answer.

aroshlakshan 26-Aug-11 1:42am

bookingtable.Rows(bookingtable.Rows.Count - 1).Delete();
this dosen't work. it says .Rows cannot be used like a method.

Suresh Suthar · Answer 2 · 2011-08-25T19:15:00

Solution 2

To delete last row of DataTable use this..
[Alternate Solution]

C#

bookingtable.Rows.RemoveAt(bookingtable .Rows.Count-1]);

Posted 25-Aug-11 19:15pm

Suresh Suthar

Updated 25-Aug-11 19:18pm

v2

Comments

aroshlakshan 26-Aug-11 1:43am

i tried this and what happened is, it added the last row to the gridview every time i click the button instead of deleting

Suresh Suthar 26-Aug-11 1:54am

Can you post your latest code?

Prerak Patel 26-Aug-11 1:45am

My 5. I just forgot about Remove and RemoveAt.

aroshlakshan 26-Aug-11 2:05am

this is the code. the reason for adding rows instead of deleting,
it adds the existing values in Vn,Vy,Vs to the table when i press the cancelDVD button because the page reloads. i need a solution to solve that. can you help??

public partial class Myreservations : System.Web.UI.Page
{

DBAccess isusrobj = new DBAccess();

protected void Page_Load(object sender, EventArgs e)
{
String email = isusrobj.setSessionVar();

if (email != (String)Session["email"]) //**********this is the problemo**************
{

HyperLink choosemore = new HyperLink();
ImageButton cancelDVD = new ImageButton();
ImageButton BookDVDs = new ImageButton();

choosemore.ImageUrl = "~/Images/more.gif";
choosemore.NavigateUrl = "Movies.aspx";

cancelDVD.ImageUrl = "~/Images/cancel.gif";
//cancelDVD.OnClientClick = cancelDVDs();

BookDVDs.ImageUrl = "~/Images/bookdvds.gif";
//BookDVDs.OnClientClick = BookDVDsinDB();

Panel1.Controls.Add(choosemore);
Panel1.Controls.Add(cancelDVD);
Panel1.Controls.Add(BookDVDs);

String Mname = Request.QueryString["Vn"];
String Myear = Request.QueryString["Vy"];
String Mstars = Request.QueryString["Vs"];

DataTable bookingtable = (DataTable)Session["table"];
DataRow row = bookingtable.NewRow();
row["Movie Name"] = Mname;
row["Movie Year"] = Myear;
row["Starring"] = Mstars;

if (bookingtable.Rows.Count == 0)
{

bookingtable.Rows.Add(row);
bookingtable.AcceptChanges();
Reservations.DataSource = bookingtable;
Reservations.DataBind();
Session.Add("table", bookingtable);

}
else
{
bookingtable = (DataTable)Session["table"];
bookingtable.Rows.Add(row);
bookingtable.AcceptChanges();
Session.Add("table", bookingtable);
Reservations.DataSource = bookingtable;
Reservations.DataBind();
}

}
else
{
loginLabel.Text = "You have not logged in.Please log in to book the DVD!";
}
}

private string BookDVDsinDB()
{

throw new NotImplementedException();
}

private string cancelDVDs()
{
DataTable deleteRows = (DataTable)Session["table"];
if (deleteRows.Rows.Count > 0)
{
deleteRows.Rows[deleteRows.Rows.Count - 1].Delete();
deleteRows.AcceptChanges();
Session.Add("table", deleteRows);
}
else
{
loginLabel.Text = "You haven't selected any DVDs to cancel!";
}
throw new NotImplementedException();
}

}