How to refill a dataset?

[cstrader232]

I have this code in my vb.net program. Me.TickersTableAdapter.Fill(Me.DataSet1.Tickers) It fills the data from the external file fine. However, I'd like to be able to refill the data after it has been changed by an external program. Calling the line a second time doesn't work because I get "datareader already active on this command" error. How can I refill the data from the external file? tia

[Dave Sexton]

create another data adapter?

[cstrader232]

Sorry, that doesn't make sense to me. I have one dataset that I want to keep updated. The dataset can be updated by an external program. I would like to refresh the dataset by re-reading it periodically to reflect those external changes. This seems like it must be possible using only one data adapter. But maybe I'm missing something. thanks for your response!

[karansharma]

first of all make a function to fill dataset . then whenever u want to reload ur dataset , call ur function . but dont forget to clear the table(Tickers) in which it is going to load b4 calling the function . i hope it might work for u .