Printable View
Hey guys. Looking for some help on manually creating a DataSet. The Data is coming from a parsed text file but I need to first build my DataTables based on the columns specified in a SQL Database so that i can populate the Set from my parsed data, the update the database with the dataset. Anyone got a good chunk of code on doing this easily. I can figure it out, but thought I would see who may have something ready made.
Got it . It is FillSchema method of the DataAdapter.
Watch out for performance issues Cander, the FillSchema() method can be a monster (at least the articles that I have read claim this..).
hmm doesnt seem to be a problem. And I dont see any reason why there should be problem. FillSchema does exactly what Fill does, except for putting in the actual data.. Perhaps it has to do with the 2nd param where you choose mapped or source. Dont know what they mean, but i choose source.:confused:
I do know that it makes multiple hits to the db for primary key and unique key constraint/information.
hmm. ok. Well it seems to be ok. The db and the app are both on my machine and doing the stuff in a new thread. No bad performance spikes that I noticed.