Delete data from DataGridView with confirmation using C# in Windows Forms Application

ieee

SOLVED CLOSED ACTIVE ANSWERED
User: ieee
Posted: on May 20, 2016 05:27 AM
Forum: Windows Basics
Answer: 1
Views: 2681
Sample Code: Download

iam using this code but it not working

private void dgvstudentreg_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
    if (dgvstudentreg.CurrentCell.Value.ToString() == "Edit")
    {
        cs_field.Code = dgvstudentreg.SelectedRows[0].Cells[0].Value.ToString();
        txtRegno.Text = dgvstudentreg.CurrentRow.Cells["_regno"].Value.ToString();

        txtFName.Text = dgvstudentreg.CurrentRow.Cells["fname"].Value.ToString();
        txtMName.Text = dgvstudentreg.CurrentRow.Cells["mname"].Value.ToString();
        txtLName.Text = dgvstudentreg.CurrentRow.Cells["lname"].Value.ToString();
        txtBloodGrp.Text = dgvstudentreg.CurrentRow.Cells["Bloodgrp"].Value.ToString();
        txtHeight.Text = dgvstudentreg.CurrentRow.Cells["Height"].Value.ToString();
        txtWeight.Text = dgvstudentreg.CurrentRow.Cells["Weight"].Value.ToString();
        dtpBirthDate.Text = dgvstudentreg.CurrentRow.Cells["DateOfBirth"].Value.ToString();
        cmbGender.Text = dgvstudentreg.CurrentRow.Cells["Gender"].Value.ToString();
        txtCast.Text = dgvstudentreg.CurrentRow.Cells["Cast"].Value.ToString();
        pic_SPhoto.ImageLocation = dgvstudentreg.CurrentRow.Cells["Photo"].Value.ToString();
        txtCAddress.Text = dgvstudentreg.CurrentRow.Cells["CAddress"].Value.ToString();
        txtPAddress.Text = dgvstudentreg.CurrentRow.Cells["PAddress"].Value.ToString();
        txtMobileno1.Text = dgvstudentreg.CurrentRow.Cells["MobileNo1"].Value.ToString();
        //txtMobileno2.Text = dgvstudentreg.CurrentRow.Cells["MobileNo2"].Value.ToString();
        // txtEmailid.Text = dgvstudentreg.CurrentRow.Cells["EmailId"].Value.ToString();
        txtFatherfullname.Text = dgvstudentreg.CurrentRow.Cells["FatherName"].Value.ToString();
        txtFoccupation.Text = dgvstudentreg.CurrentRow.Cells["FatherOccupation"].Value.ToString();
        txtF_Mobileno.Text = dgvstudentreg.CurrentRow.Cells["FatherMobileno"].Value.ToString();
        //txtF_Officeno.Text = dgvstudentreg.CurrentRow.Cells["FatherOfficeno"].Value.ToString();
        txtMotherfullname.Text = dgvstudentreg.CurrentRow.Cells["MotherName"].Value.ToString();
        txtMoccupation.Text = dgvstudentreg.CurrentRow.Cells["MotherOccupation"].Value.ToString();
        txtM_Mobileno.Text = dgvstudentreg.CurrentRow.Cells["MotherMobileNo"].Value.ToString();
        //txtM_Officeno.Text = dgvstudentreg.CurrentRow.Cells["MotherOfficeNo"].Value.ToString();
        txtP_Schoolname.Text = dgvstudentreg.CurrentRow.Cells["PrvSchoolName"].Value.ToString();
        txtP_Durationform.Text = dgvstudentreg.CurrentRow.Cells["PrvDurationfor"].Value.ToString();
        txtP_Durationto.Text = dgvstudentreg.CurrentRow.Cells["PrvDurationto"].Value.ToString();
        txtP_Class.Text = dgvstudentreg.CurrentRow.Cells["PrvClass"].Value.ToString();
        //txtP_Marks.Text = dgvstudentreg.CurrentRow.Cells["PrvMarks"].Value.ToString();
        txtP_Contactno.Text = dgvstudentreg.CurrentRow.Cells["PrvSchoolcontno"].Value.ToString();


        btnSave.Text = "&Update";
        btnNew.Enabled = true;
        btnSave.Enabled = true;
    }
    if (dgvstudentreg.CurrentCell.Value.ToString() == "Delete")
    {
        if (DialogResult.Yes == MessageBox.Show("\tAre you sure to Delete this Student Details?\t\t", "Delete?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
        {
            //cs_field.Code1 = dgvstudentreg.CurrentRow.Cells["_regno"].Value.ToString();
            txtRegno.Text = dgvstudentreg.CurrentRow.Cells["_regno"].Value.ToString();
            cs_field.Code = txtRegno.Text;
            cs_studentreg.Deletestudent(cs_field);
            ClearField();
            MessageBox.Show("\t Student Details Deleted Successfully.\t\t", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
            frmStudentRegistration_Load(this, EventArgs.Empty);
            btnSave.Text = "Save";
        }
    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on May 20, 2016 06:03 AM
Modified: on Sep 15, 2017 03:47 AM
Report

Here i have created sample using your code. In the message box i have shown the regno. So you need to write the code for delete the record by passing the regno.

Code

public Form1()
{
    InitializeComponent();
    BindGrid();
}

private void BindGrid()
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[3] { new DataColumn("_regno", typeof(int)),
                    new DataColumn("Name", typeof(string)),
                    new DataColumn("Country",typeof(string)) });
    dt.Rows.Add(1, "John Hammond", "United States");
    dt.Rows.Add(2, "Mudassar Khan", "India");
    dt.Rows.Add(3, "Suzanne Mathews", "France");
    dt.Rows.Add(4, "Robert Schidner", "Russia");
    dgvstudentreg.DataSource = dt;
}

private void dgvstudentreg_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    if (dgvstudentreg.CurrentCell.Value.ToString() == "Delete")
    {
        if (DialogResult.Yes == MessageBox.Show("\tAre you sure to Delete this Student Details?\t\t", "Delete?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
        {
            string regNo = dgvstudentreg.CurrentRow.Cells["_regno"].Value.ToString();
            // Write code for delete.
            MessageBox.Show("Reg No: " + regNo);
        }
    }
     BindGrid();
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Delete data from DataGridView with confirmation using C# in Windows Forms Application

Company

Explore

Follow us

Contact Us