datagridview and listview refresh after data getting updated

[Syed Hadi]

                //user list view
                da = new SqlDataAdapter("SELECT * FROM [user]", con);
                DataTable t = new DataTable();
                ds = new DataSet();
                da.Fill(ds);
                 t = ds.Tables[0];
                listView1.View = View.Details;
                for (int i = 0; i < t.Rows.Count; i++)
                {
                    DataRow dr= t.Rows[i];
                    ListViewItem item = new ListViewItem(dr["id"].ToString());
                    //item.Text = dr ["id"].ToString();        
                    item.SubItems.Add(dr["name"].ToString());
                    item.SubItems.Add(dr["uname"].ToString());
                    item.SubItems.Add(dr["profession"].ToString());
                    listView1.Items.Add(item);
                    //listView1.Items.Add(dr[0].ToString()).SubItems.Add(dr[1].ToString());
                    con.Close();
 
                }
                //data grid view user inssert or delete
                con.Open();
                da = new SqlDataAdapter("SELECT * FROM [user]", con);
                DataTable t1 = new DataTable();
                da.Fill(t1);
                dataGridView1.DataSource = t1;
                con.Close();
 

i tried with datagridview.refresh, update but its not working can any body sugesst me what to do for refresing the data ....do timer we have to use..? if yes then how ...?
in advanced thanks

[adriancs]

maybe somewhere else is resetting the datagridview.

[Syed Hadi]

@adriancs where that resetting boss....dat only i want .?

[adriancs]

assume that table "user" has rows...
I am 100% sure that this code is working with no error.

con.Open();
da = new SqlDataAdapter("SELECT * FROM [user]", con);
DataTable t1 = new DataTable();
da.Fill(t1);
dataGridView1.DataSource = t1;
con.Close();

You can try to create another form and build only a datagridview.
and prove it.

therefore, there is something wrong with your other code which is not shown in your 1st post.

[Syed Hadi]

this is working boss... but its not getting refresh when update or insert done.....

[adriancs]

hi boss, manually update it?

public void UpdateGridView()
{
    con.Open();
    da = new SqlDataAdapter("SELECT * FROM [user]", con);
    DataTable t1 = new DataTable();
    da.Fill(t1);
    dataGridView1.DataSource = t1;
    con.Close();
}

public void UpdateData()
{
    // Do something Update
    UpdateGridView();
}

public void InsertData()
{
    // Do something Insert
    UpdateGridView();
}

[Syed Hadi]

@adriancs thanks for this idea boss i think it will work ........