Visual Basic Refreshing Datagridview

I am not a good programmer, but i can show a simple logic on how to refresh a datagridview. Assuming our event is in button 1, i create a whole function that can be able to call a datagrid. (Inside the whole form, you have to call the whole code of the data view , for you to do it, I created a function. named "view()") (after deleting,adding and updating a data, I'm sure u want to see it immediately in datagridview, so what we have to do is call it once again from the sql. to do that, call the view function which we created.) This is my code for further reference; Public Sub view1() Dim objcon As New SqlConnection("server=DIMEE-PC\SQLEXPRESS;database=MCLC_Enrollment System 2010;Trusted_connection=true") Dim objdataadapt As New SqlDataAdapter() Dim objset As New DataSet() objdataadapt.SelectCommand = New SqlCommand() objdataadapt.SelectCommand.Connection = objcon objdataadapt.SelectCommand.CommandText = "SELECT * FROM dbo.paymentview where StudentNumber = " & txtId.Text & " order by date desc " objdataadapt.SelectCommand.CommandType = CommandType.Text objcon.Open() objdataadapt.Fill(objset, "paymentview ") objdataadapt.Dispose() objcon.Close() DataGridView1.AutoGenerateColumns = True DataGridView1.DataSource = objset DataGridView1.DataMember = "paymentview " objdataadapt = Nothing objcon = Nothing End Sub Hope this little idea of mine would help to fixed your project.