Refresh DataSet

[tbpowers]

I have created two new stored procedures in my database, but when I refresh my dataset in VS they do not show up. How do I accomplish this without having to create a new datasource? Any help will be greatly appreciated.

 

[s1ckOh]

Clear your dataset and then refill it with the new data eg...

cn = New OleDbConnection("Provider=M...")
Dim ds As DataSet = Me.DataSet1
ds.Tables("Table").Rows.Clear()
da = New OleDbDataAdapter("SELECT * FROM Table", cn)
da.Fill(ds, "Table")

Have fun

 

[tbpowers]

Thank you very much.

 

[jmcilhinney]

I don't think that s1ckOh was actually answering the question you were asking. If I'm interpreting this correctly then the answer is thus:

Open the Data Sources window, select your data source and then click the button to re-run the configuration wizard. That will allow you to select the new procedures and generate additional DataTables and TableAdapters for them.

 

[tbpowers]

That is how I am doing it. Thanks so much for the reply.