Delete the selected rows from Datagridview

Question

0.00/5 (No votes)

See more:

Hi, Can anyone ahare code snippet for deleting the selected rows(multi select) from a datagridview. Before delete I want to check whether the items going to be deleted are added by the user who has logged in.

Thanks in advance

private void btnDelete_Click(object sender, EventArgs e)
        {
            dgDtParameters.AllowUserToDeleteRows = true;
            System.Data.DataTable objDt = new System.Data.DataTable();
            DataRow objdrDelete;
            DataSet dsAdmin = new DataSet();
            try
            {
                objConnection = new DBAccess();
                SqlParameter[] sqlparamAdmin = {
                                                   new SqlParameter("@accountID",iaccountID),
                                                   new SqlParameter("@projectID",iprojectID),
                                                   new SqlParameter("@componentID",icomponentID),
                                                   new SqlParameter("@createdBy",CCommonInfo.iUserID),
                                               };
                dsAdmin = objConnection.GetDataSet("prcDisplayAdmindataTemplate", sqlparamAdmin);
                if (iRoleID == 1 || iRoleID == 2 || iRoleID == 3)
                {
                    if (MessageBox.Show(CompCreatorMsg.Msg_DPDelete, CompCreatorMsg.Title_DPDelete, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        objDt = dsobbtemp.Tables[0];
                        objdrDelete = objDt.NewRow();
                        //if (objDt != null)
                        {
                            for (int i = 0; i < objDt.Rows.Count; i++)
                            {
                                objdrDelete["objectRevisedName"] = objDt.Rows[i]["objectRevisedName"].ToString();
                                srowFilter = "objectRevisedName = '" + objdr["objectRevisedName"].ToString() + "'";
                                if (dsAdmin.Tables[0].Select(srowFilter).Length == 0)
                                {
                                    SqlParameter[] sqlparam = {
                                                  new SqlParameter("@objectID",Convert.ToString(objDt.Rows[i]["objectID"]))
                                              };
                                    iResults = objConnection.ExecuteCommand("prcDeleteDataTemplate", sqlparam);
                                }
                            }
                        }
                        objDt.Clear();
                        objDt.Dispose();
                    }
                }
            }
            catch (Exception exGeneral)
            {
                MessageBox.Show(exGeneral.Message + exGeneral.StackTrace.ToString());
            }
        }

Posted 19-Sep-11 3:17am

CyborgForever

Add a Solution

2 solutions

Add a Solution

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

MaulikDusara · Answer 1 · 2011-09-19T20:05:00

Hi,

Refer below:

http://social.msdn.microsoft.com/Forums/en/winformsdatacontrols/thread/fbe691ae-ec83-4a09-8766-0088cfcc1ea3[^]

http://stackoverflow.com/questions/777208/how-to-delete-row-from-datagridview-with-a-delete-button[^]

http://stackoverflow.com/questions/5539243/how-to-delete-a-selected-row-from-datagridview-and-database[^]

prakash00060 · Answer 2 · 2011-09-19T19:37:00

try
{

sqlConnection.Close();
int nn = dataGridView1.SelectedCells[0].RowIndex;
string s = dataGridView1[0, nn].Value.ToString();
int n = Convert.ToInt32(s);
SqlCommand cmd = new SqlCommand("delete from Master_Vlc where Vlc_Code=" + n, sqlConnection);
ds = new DataSet();

sqlConnection.Open();
sqlDataAdapter = new SqlDataAdapter(cmd);

sqlDataAdapter.Fill(ds, "Master_Vlc");
MessageBox.Show("Value Deleted");
sqlConnection.Close();
dataGridView1.Rows.RemoveAt(nn);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}

Delete the selected rows from Datagridview

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Delete the selected rows from Datagridview

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us