Refresh the Dataset

Question

I don't know if I'm asking it in the good way but I have a issue with Dataset TableAdapter ect. When I insert a new data in a database the new data is not visible in mine example combobox or listview or datagrid. How can I Refresh the this using a code when I'm inserting a new data

mirko boggian · Answer

wonderful!!

Arnold Petrona · Answer

No porblem thanks I will try it later

Muhammad Shahid Farooq · Answer

OleDbDataAdapter objOleDbDataAdapter = new OleDbDataAdapter(); objOleDbDataAdapter.Fill(objDataSet); sorry for inconvience.

Arnold Petrona · Answer

But i use OLedb.

Muhammad Shahid Farooq · Answer

SqlDataAdapter.fill() fill the dataset again after ExecuteNonQuery()

Arnold Petrona · Answer

I'm doing it through ExecuteNonQuery (Oledb). But I ask get some data from using the Dataset

Muhammad Shahid Farooq · Answer

You are inserting data through SqlCommand.executeNOnQuery() or SqlDataAdapter.Update()