How to refresh datagridview in window application

Question

Rajanikant Hawaldar · Answer

Bind dataGridViewNamw.DataSource= ... will resolve your issue

Amit Mohanty · Answer

On refresh button click event rebind the datagridview once again. Create a function to bind the datagridview and use it when you want to refresh the datagridview. public void DataGridViewRefresh() { SqlConnection sqlConnection = new SqlConnection(dbConnection); sqlConnection.Open(); string sqlQuery = your query to get data from database ; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlQuery sqlConnection); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); dataGridView1.DataSource = dataTable; sqlConnection.Close(); }

Shivam Payasi · Answer

Hello Manju Jd I think you are performing some insert or update operation on the data table after that you want to see the updated DataGridView. now you need to create a method Named LoadData() or RefreshGrid() whatever you want it's your choice and this method contains code private void RefreshGrid() { con = db.connection();//Here you can simply add your connection con.Open(); SqlDataAdapter sd = new SqlDataAdapter(select *from TblDeptcon);//write your Query to get data dataGridView1.DataSource = null;//this is the main Part Here you need to clean all data that was presented in the Grid DataSet ds = new DataSet(); sd.Fill(ds TblDept); dataGridView1.DataSource = ds.Tables[0];//Now here we are Reloading the Gtrid } Here in this method we are removing all Old data from GridView and Adding Updated data on the Grid You can use your own code to load data on GridView Important part is to remove All data from the grid by dataGridView1.DataSource = null; and Reload GridView With your Data you just need to call this method whenever you need to Refresh the GridView it will work. Thanks.. for Your Query

Vishal Yelve · Answer

Please find this link as your reference https://www.aspsnippets.com/Articles/Refresh-DataGridView-after-record-delete-in-Windows-Application-using-C-and-VBNet.aspx#:~:text=and%20VB.Net.-When%20the%20Delete%20Button%20is%20clicked%2C%20a%20Confirmation%20MessageBox%20willusing%20C%23%20and%20VB.Net.