User Profile

Collapse

Profile Sidebar

Collapse
Ken Alexander
Ken Alexander
Last Activity: May 20 '09, 11:23 PM
Joined: Apr 16 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ken Alexander
    replied to XML to DataSet Unique ID
    in XML
    Thank you for the response. I guess I misunderstood DTD. How would I set up an XML so that I can specify the ID?
    See more | Go to post

      Leave a comment:

    • Ken Alexander
      started a topic XML to DataSet Unique ID
      in XML

      XML to DataSet Unique ID

      Hello,

      I have a very simple xml file that I am reading into a DataSet using VB.NET. The problem I am having is setting my own unique IDs for the elements. After creating a DataSet of the below XML, a new column is added to each table. In this case Product_ID is not used, but a new column of Product_ID_0 is used. From what I have read I need to use DTD to set this. I tried it as follows and no luck. I would appreciate any help....
      See more | Go to post
      • Ken Alexander
        replied to ADO.NET Inserts
        in .NET
        I have not tried stored procedures yet. Will using SP make that much of a difference?...
        See more | Go to post

          Leave a comment:

        • Ken Alexander
          replied to ADO.NET Inserts
          in .NET
          I'm running these tests on a local server....
          See more | Go to post

            Leave a comment:

          • Ken Alexander
            replied to ADO.NET Inserts
            in .NET
            Yes I have tried the DataAdapter's Update method. The results are slower using Update. Thank you though....
            See more | Go to post

              Leave a comment:

            • Ken Alexander
              started a topic ADO.NET Inserts
              in .NET

              ADO.NET Inserts

              I'm finding it hard to believe that this is "as good as it gets" when inserting rows into a database. The code below inserts 40,000 rows in about 1.7 seconds. I have read other posts that folks are getting much quicker times. Is this as good as it gets? Thank you for any insight.

              Code:
              Private Sub InsertTest(ByVal Connection As SqlConnection)
            Using DBTrans As SqlTransaction = Connection.BeginTransaction
              ...
              See more | Go to post
              No activity results to display
              Show More
              Working...