Solved

Dataset does not return 1st row?

Posted on 2009-07-14
3
201 Views
Last Modified: 2012-05-07
This might be easy but...
I've opened a CSV file using ADO, filled a DataSet from the result but I'm not getting the first row. Is this a 0 based thing?
cn = New ADODB.Connection
        cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=" & strInputFilePath & ";" & _
                "Extended Properties='text;HDR=NO;FMT=Delimited'")
        'create a new recordset
        rsSource = New ADODB.Recordset
        rsSource.CursorLocation = ADODB.CursorLocationEnum.adUseClient
        rsSource.CursorType = ADODB.CursorTypeEnum.adOpenStatic
        rsSource.LockType = ADODB.LockTypeEnum.adLockBatchOptimistic
        rsSource.Open("SELECT * FROM [" & System.IO.Path.GetFileName(strInputFile) & "]", cn)
        rsSource.ActiveConnection = Nothing
        cn.Close()
 
        Dim daDataAdapter As New System.Data.OleDb.OleDbDataAdapter()
        Dim dsDataSet As New DataSet()
        Dim drRow As DataRow
        daDataAdapter.Fill(dsDataSet, rsSource, System.IO.Path.GetFileName(strInputFile))
        
        Dim lngMaxRows As Long = dsDataSet.Tables(0).Rows.Count
        Dim sw As StreamWriter
        Dim dcColumn As DataColumn
       
        sw = New StreamWriter(strOutputFile)
        'Loop through Input file dataset
        For Each drRow In dsDataSet.Tables(0).Rows
 
            For Each dcColumn In dsDataSet.Tables(0).Columns
                If dcColumn.ColumnName.ToString = "SEQ_NO" Then
                    'format this field
                    str = str & drRow("SEQ_NO").ToString("00000000")
                Else
                    str = str & drRow(dcColumn.ColumnName) & Chr(9)
                End If
            Next
            sw.WriteLine(str)
        Next

Open in new window

0
Comment
Question by:wessir
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 41

Expert Comment

by:guru_sami
ID: 24854150
Do you mean your query itself is not returning the first row?
Is the dsDataSet.Tables(0).Rows.Count returning right count?

0
 

Author Comment

by:wessir
ID: 24854546
I don't know if it's not returning all or if the dataset isn't filled properly.  dsDataSet.Tables(0).Rows.Count returns 999 instead of the 1,000 records in the original CSV file.  The output file is missing the first record so it seems the 999 count is correct.
0
 

Accepted Solution

by:
wessir earned 0 total points
ID: 24854589
I added the following line to my Schema.ini file and that took care of it...
ColNameHeader=False
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question