Results 1 to 6 of 6

Thread: Manually build Dataset[RESOLVED]

  1. Apr 22nd, 2003, 02:02 PM #1
    Cander
    Cander is offline

    Thread Starter
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913

    Manually build Dataset[RESOLVED]

    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.
    Last edited by Cander; Apr 22nd, 2003 at 02:29 PM.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
  2. Apr 22nd, 2003, 02:22 PM #2
    Cander
    Cander is offline

    Thread Starter
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    Got it . It is FillSchema method of the DataAdapter.
    Last edited by Cander; Apr 22nd, 2003 at 02:29 PM.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
  3. Apr 22nd, 2003, 03:52 PM #3
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    Watch out for performance issues Cander, the FillSchema() method can be a monster (at least the articles that I have read claim this..).
    Reply With Quote Reply With Quote
  4. Apr 23rd, 2003, 08:22 AM #4
    Cander
    Cander is offline

    Thread Starter
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    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.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
  6. Apr 23rd, 2003, 08:35 AM #5
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    I do know that it makes multiple hits to the db for primary key and unique key constraint/information.
    Reply With Quote Reply With Quote
  7. Apr 23rd, 2003, 08:58 AM #6
    Cander
    Cander is offline

    Thread Starter
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    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.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width