export to excel problem

[ganjafarmerIT]

Hi folks, I'm having some weird problems with my application.

I'm retreiving data from an mssql db and then I export that data in excel format file. The problem I'm facing is that sometimes when a user opens that excel file, for some reason the data in the file is mixed with old data.
Really weird. If I look at my code it shouldn't be possible since I'm not storing anyhting in memory. I retreive the data, generate a filename each time, write the data in excel format to the file and close everything.

anyone encountered this before?

thanks in advance

 

[need2progm]

I did have this issue once... My Dataset still had "old" data in so when I re-populated it the old data was still around thus was put into my output stream to the pdf file I was creating.

I found out that before I could run my sql query I had to do this..
Try
DataSet.Table.Rows.Clear() 'clear all rows
SqlSelect(JobID) ‘call the sql
Catch MyEx As InvalidJobTitle
Throw MyEx
End Try

Then I could repopulate the Dataset then I could do what I needed.

I hope this helps