how to automatical update datagrid after insert in c#winform

Question

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" ); } }

James Axsom · Answer

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 Hawaldar · Answer

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