refresh datagridview

Question

hello :) how can i refresh my datagridview after deleting/insertig a row in database? thanks.

Kunal Vaishya · Answer

Hello , try this may be use full re allocate the datatable or dataset before fill it ds= new DataSet(); Adpt.Fill(ds)

Sreejesh SP · Answer

page.cs SqlConnection con = new SqlConnection(@" "); SqlCommand cmd = new SqlCommand(); protected page load(object sender,event arguments) { if(!ispostback) { this.populate()//first time fill the grid view } } private populate() { DataTable dt = new System.Data.DataTable(); cmd.Connection = con; cmd.CommandText = "select LastName,FirstName,Title,City from dbo.Employees"; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); gridview.datasource=dt; gridview.databind(); } protected void delete(object sender,event arguments) { //input delete function //call populate function this.populate(); } Dear popa, In the above code is sample, After your Update or insert function then call the populate function from database,then your Data Grid View refresh Thanks Sreejesh S P

Harshal Patil · Answer

just put Your Grid in Update_Panel.... ID = "UpdatePanel1" runat = "server" > ControlID = "Timer1" EventName = "Tick" /> ID = "Panel1" runat = "server" Height = "250px" Width = "250px" > ID = "Gridview1" runat = "server" >

Kunal Vaishya · Answer

Hello , try this may be use full re allocate the datatable or dataset before fill it ds= new DataSet(); Adpt.Fill(ds)

Sreejesh SP · Answer

Welcome Mr. Popa

Violeta Popa · Answer

Thanks Sreejesh for your answer, indeed it refreshes my datagrid but it displays twice the records, the originals one, then the refreshed..but i want only the refreshed :(

Satyapriya Nayak · Answer

http://stackoverflow.com/questions/14374348/refresh-button-refreshing-data-grid-view-after-inserting-deleting-updating

refresh datagridview

Answers (7)