good article, as a beginner for ADO.net, I have one question.

how many new rows will insert by your script? one, number of rows, or the loop will run forever?

Do Until rs.EOF

    rs.AddNew

    rs.Fields("CustomerID") = "SSC"

    rs.Fields("CompanyName") = "SQLServerCentral.Com"

    rs.update

Loop