how to automatical update datagrid after insert in c#winform

Oladotun Obileye

Good day everyone i am working on an application in c# windows form that has two usercontrol place on a form.

the first one is for registration i.e to register the second one is to view the registered users, to crud. and also has a datagriedview. whenever i register a new it does not show in the second usercontrol except i exit and re-run the code before it will get updated in the datagridview. please i want whenever i insert a new record it should show in the second usercontrol. not only datagridview even label thanks to get updated.

this is the usercontrol for registration

private void btnreg_Click(object sender, EventArgs e)
{
userprofile up = new userprofile();
if (txtempno.Text != null && txtfullname.Text != null && dob.Value != null && txtdept.Text != null && txtoccupation.Text != null && txtmaritalstatus.SelectedItem != null && txtemail.Text != null && txtpost.Text != null && txthaddress.Text != null && txtpno.Text != null && txtnation.Text != null && txtorigin.Text != null && pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byte[] img = ms.ToArray();
if (rfemale.Checked == true)
{
gender = "Female";
}
else if (rmale.Checked == true)
{
gender = "Male";
}
SqlDataAdapter da = new SqlDataAdapter("Select * FROM Registrationform where Employementnumber='" + txtempno.Text + "' or Email='" + txtemail.Text + "' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count >= 1)
{
MessageBox.Show("already exist");
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO Registrationform([Employementnumber],[FullName],[Dateofbirth],[Gender],[Occupation],[Maritalstatus],[Email],[Department],[Position],[HomeAddress],[Phonenumber],[Nationality],[Stateoforigin],[image]) VALUES (@empno,@fullname,@dob,@gen,@occ,@ms,@email,@dept,@post,@haddress,@pno,@nation,@soo,@img)";
cmd.Parameters.AddWithValue("@empno", txtempno.Text);
cmd.Parameters.AddWithValue("@fullname", txtfullname.Text);
cmd.Parameters.AddWithValue("@dob", dob.Value);
cmd.Parameters.AddWithValue("@gen", gender);
cmd.Parameters.AddWithValue("@occ", txtoccupation.Text);
cmd.Parameters.AddWithValue("@ms", txtmaritalstatus.GetItemText(txtmaritalstatus.SelectedItem));
cmd.Parameters.AddWithValue("@email", txtemail.Text);
cmd.Parameters.AddWithValue("@dept", txtdept.Text);
cmd.Parameters.AddWithValue("@post", txtpost.Text);
cmd.Parameters.AddWithValue("@haddress", txthaddress.Text);
cmd.Parameters.AddWithValue("@pno", txtpno.Text);
cmd.Parameters.AddWithValue("@nation", txtnation.Text);
cmd.Parameters.AddWithValue("@soo", txtorigin.Text);
cmd.Parameters.AddWithValue("@img", img);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("data entered");
da.Fill(dt);
BindingSource bd = new BindingSource();
up.dtuserpro.DataSource = dt;
up.dtuserpro.DataSource = bd;
con.Close();
}
}
else
{
MessageBox.Show("Please Fill In All The Necessary Informations");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

James Axsom7y ago
Hi Oladotun.

Short answer is to refresh the code which populates your datagrid.

You make a new row with data entry, save the new row to the sql server and execute the datagrid population code.

I'm enclosing a sample project.

Here is my code showing two main subroutines:
1) Inserts a new customer in the customer table
2) Refreshes or populates the datagrid view

New Row: dbo.Customer
Look at the bottom in the finally brackets where I'm refreshing my datagrid
private void BtnSave_Click(object sender, EventArgs e)
{
    // Event Handler: BtnSave_Click
    // Return: None
    // Purpose: Insert a new row into dbo.Customer

    try
    {
        // data variables
        string firstName = txtFirstName.Text;
        string lastName = txtLastName.Text;

        int age = 0;
        int.TryParse(nudAge.Value.ToString(), out age);

        string occupation = txtOccupation.Text;
        decimal income = nudIncome.Value;

        // ADO.NET object variables
        System.Data.SqlClient.SqlConnection cnn = null;
        System.Data.SqlClient.SqlCommand cmd = null;

        // Getting connected to my sql server
        cnn = new System.Data.SqlClient.SqlConnection("Server=DESKTOP-9V39JCA; Database=CSharpCorner; Trusted_Connection=True;");

        // Configure Command
        cmd = new System.Data.SqlClient.SqlCommand();
        cmd.Connection = cnn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "Customer_Insert";
        // Command Sql Parameter
        cmd.Parameters.AddWithValue("@FIRSTNAME", firstName);
        cmd.Parameters.AddWithValue("@LASTNAME", lastName);
        cmd.Parameters.AddWithValue("@AGE", age);
        cmd.Parameters.AddWithValue("@OCCUPATION", occupation);
        cmd.Parameters.AddWithValue("@INCOME", income);

        // insert row
        // Open
        if (cnn.State != ConnectionState.Open)
        {
            cnn.Open();
        }

        // Insert
        cmd.ExecuteNonQuery();

        // Close
        if (cnn.State != ConnectionState.Closed)
        {
            cnn.Close();
        }

        // Refresh User Interface
        ResetDataEntry();
    }
    catch (Exception e1)
    {
        MessageBox.Show("Error" + e1.Message);
    }
    finally
    {
        PopulateDataGrid();
    }
Datagrid population
private void PopulateDataGrid()
{
    // Subroutine: PopulateDataGrid
    // Return: None
    // Purpose: Populate the Datagrid with data from a datasource

    try
    {
        // purge DataGridView Datasource
        dgvCustomer.DataSource = null;

        // ADO.NET object variables
        System.Data.SqlClient.SqlConnection cnn = null;
        System.Data.SqlClient.SqlDataAdapter ad = null;
        System.Data.SqlClient.SqlCommand cmd = null;
        System.Data.DataTable dt = null;

        // Getting connected to my sql server
        cnn = new System.Data.SqlClient.SqlConnection("Server=DESKTOP-9V39JCA; Database=CSharpCorner; Trusted_Connection=True;");

        // Configure Command
        cmd = new System.Data.SqlClient.SqlCommand();
        cmd.Connection = cnn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "Customer_Select";

        // Configure Data Adapter
        ad = new System.Data.SqlClient.SqlDataAdapter(cmd);

        // Configure Data Table
        dt = new System.Data.DataTable("Customer");

        // Acquire Data
        // Note: The data adapter automatically opens and then closes the connection on Fill
        ad.Fill(dt);

        // reset DataGrid DataSource
        dgvCustomer.DataSource = dt;
    }
    catch (Exception e)
    {
        MessageBox.Show("Error" + e.Message);
    }
If you download the project, it won't run because its set to run on my sql server and your sql server won't have my database and tables. But you can peruse the code to see how all this works.
Sample pic

Sample project created in Microsoft Visual Studio 2019 Community Edition.
Microsoft Visual Studio Community 2019 Community Edition can be downloaded for your personal use free of charge.
Rajanikant Hawaldar7y ago
Hi Oladotun,

refer this post

https://docs.microsoft.com/en-us/dotnet/framework/winforms/controls/how-to-bind-data-to-the-windows-forms-datagridview-control

Thanks