Ad:

C# Discussion Thread
Unsolved
Views: 1715

Mar 18th, 2010

Delete Row

Expand Post »

Hey,

I currently have a dataGridView which displays information from my SQL database. I have a button that I use to update/add into the SQL database - for example a user ammends a field in the dataGridView this automatically updates the database.

I now want to implement a button that deletes the selected row from the database.

My dataGridView loadData:

C# Syntax (Toggle Plain Text)
        private void LoadData()
    {
        string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";
            conn = new SqlConnection(connectionString);
            sql = "SELECT * FROM coffeeType2";
 
            da = new SqlDataAdapter(sql, conn);
            conn.Open();
            ds = new DataSet();
            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(da);
            da.Fill(ds, "coffeeType2");
            bsource.DataSource = ds.Tables["coffeeType2"];
            dataGridView1.DataSource = bsource;
 
            // this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
 
            dataGridView1.AutoResizeColumns();
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
        }
        private void LoadData()
    {
        string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";
            conn = new SqlConnection(connectionString);
            sql = "SELECT * FROM coffeeType2";

            da = new SqlDataAdapter(sql, conn);
            conn.Open();
            ds = new DataSet();
            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(da);
            da.Fill(ds, "coffeeType2");
            bsource.DataSource = ds.Tables["coffeeType2"];
            dataGridView1.DataSource = bsource;

            // this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
                        
            dataGridView1.AutoResizeColumns();
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
        }

Add/Update Button:

C# Syntax (Toggle Plain Text)
        private void btnAdd_Click(object sender, EventArgs e)
        {
            DataTable dt = ds.Tables["coffeeType2"];
            this.dataGridView1.BindingContext[dt].EndCurrentEdit();
            this.da.Update(dt);
 
            LoadData();
        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            DataTable dt = ds.Tables["coffeeType2"];
            this.dataGridView1.BindingContext[dt].EndCurrentEdit();
            this.da.Update(dt);

            LoadData();
        }

How can I now create a button to delete that particular row from the database?

Thank you.

Similar Threads

Delete row permenately from database in VB.NET
How to save an edited row/Delete a row from JTable in Java
delete row from mysql using HTML button in PHP
How can I delete a row from SQL table using javascript? in ASP
stored procedure does not delete row in C#

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 18th, 2010

Re: Delete Row

http://www.codeguru.com/csharp/.net/...cle.php/c13041
http://social.msdn.microsoft.com/for...-0088cfcc1ea3/

thers many posts out there concerning this a quick google search got me this...

Last edited by phoenix911; Mar 18th, 2010 at 7:24 am.

phoenix911

Reputation Points: 38

Solved Threads: 21

Junior Poster

Offline

169 posts
since May 2009

Permalink

Mar 18th, 2010

Re: Delete Row

Ok thank you i'll have a look.

Is there anyway i'm able to get the ID of a select row at all?

Say my datagridview has ID, name, location.

When I click a cell can I get the ID of that particular row?

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 18th, 2010

Re: Delete Row

there should be a way yes

phoenix911

Reputation Points: 38

Solved Threads: 21

Junior Poster

Offline

169 posts
since May 2009

Permalink

Mar 18th, 2010

Re: Delete Row

Ok, do you have any idea how I would do this?

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 19th, 2010

Re: Delete Row

Can anyone be kind enough to help me with this?

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 19th, 2010

Re: Delete Row

Add a column in your grid with a button or an image button as is set on my example:

C# Syntax (Toggle Plain Text)
 
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton Button1 = (ImageButton)sender;
        GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent;
        DataSourceSelectArguments args = new DataSourceSelectArguments();
        DataView view = (DataView)this.SqlDataSource2.Select(args);
        DataTable table = view.ToTable();
        string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
     }
 
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton Button1 = (ImageButton)sender;
        GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent;
        DataSourceSelectArguments args = new DataSourceSelectArguments();
        DataView view = (DataView)this.SqlDataSource2.Select(args);
        DataTable table = view.ToTable();
        string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
     }

Hope it helps. let me know if you need a futher explanation. Good luck.

yaninea

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since May 2008

Permalink

Mar 24th, 2010

Re: Delete Row

Click to Expand / Collapse Quote originally posted by yaninea ...

Add a column in your grid with a button or an image button as is set on my example:
C# Syntax (Toggle Plain Text)
 
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton Button1 = (ImageButton)sender;
        GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent;
        DataSourceSelectArguments args = new DataSourceSelectArguments();
        DataView view = (DataView)this.SqlDataSource2.Select(args);
        DataTable table = view.ToTable();
        string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
     }
protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { ImageButton Button1 = (ImageButton)sender; GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent; DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = (DataView)this.SqlDataSource2.Select(args); DataTable table = view.ToTable(); string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString(); }
Hope it helps. let me know if you need a futher explanation. Good luck.

Hi i've added a button onto my datagridivew its on their as column.

I'm having trouble getting the above working however.

I've got a button (btnDelete) am I able to link that up, is there anyway I can simply get the coffeeID from the datagridview row that has been selected?

I have something like this:

C# Syntax (Toggle Plain Text)
            DataTable dt = ds.Tables["coffeeType2"];
            label1.Text = System.Convert.ToString(dt.Rows[0][2]);
            DataTable dt = ds.Tables["coffeeType2"];
            label1.Text = System.Convert.ToString(dt.Rows[0][2]);

However that just selects the DataTable id second row - how can I do it dependent on what row the user has selected?

Last edited by dawsonz; Mar 24th, 2010 at 11:04 am.

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 24th, 2010

Re: Delete Row

I've now sorted this

C# Syntax (Toggle Plain Text)
          lblCustomerID.Text = dataGridView1.CurrentRow.Cells["customerID"].FormattedValue.ToString();
 
            string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";
            conn = new SqlConnection(connectionString);
            sqlDelete = "DELETE FROM customer WHERE customerID = '" + lblCustomerID.Text + "'";
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = sqlDelete;
            cmd.Connection = conn;
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
          lblCustomerID.Text = dataGridView1.CurrentRow.Cells["customerID"].FormattedValue.ToString();

            string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";
            conn = new SqlConnection(connectionString);
            sqlDelete = "DELETE FROM customer WHERE customerID = '" + lblCustomerID.Text + "'";
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = sqlDelete;
            cmd.Connection = conn;
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

Thanks for any help anyhow.

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Mar 24th, 2010

Re: Delete Row

You will now have a gridview with a column that cointains a button "btnDelete".
You need to create an event for the btnDelete_Click and on it add the code I posted.
The code will get the row id from the row where the button was clicked, or well you can actually obtain any value from the datasource related to the grid, you just need to set the value position that you need:
string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
In the explample, the row id is the first value from the query in the SqlDataSource2, meaning, the position 0.
You need to create an event for the btnDelete_Click and on it add the code I posted.

C# Syntax (Toggle Plain Text)
#
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
#
{
#
ImageButton Button1 = (ImageButton)sender;
#
GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent;
#
DataSourceSelectArguments args = new DataSourceSelectArguments();
#
DataView view = (DataView)this.SqlDataSource2.Select(args);
#
DataTable table = view.ToTable();
#
string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
#
string name= table.Rows[grdRow.RowIndex].ItemArray[1].ToString();
}
#
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
#
{
#
ImageButton Button1 = (ImageButton)sender;
#
GridViewRow grdRow = (GridViewRow)Button1.Parent.Parent;
#
DataSourceSelectArguments args = new DataSourceSelectArguments();
#
DataView view = (DataView)this.SqlDataSource2.Select(args);
#
DataTable table = view.ToTable();
#
string id = table.Rows[grdRow.RowIndex].ItemArray[0].ToString();
#
string name= table.Rows[grdRow.RowIndex].ItemArray[1].ToString();
}

Let me know how it went, I can send you an app if you need.

yaninea

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: subset sum task

Next Thread in C# Forum Timeline: startTime

DaniWeb Message

Cancel Changes

User Name
Password