Member Avatar for smilinrascal

I need to count the number of records in an SQL database and compare it to a text file that contains a records number. Although I know how to access a SQL database in C#, I do not know how to count the number of records, or how to access the 2nd line of the count text file which contains "number of records: #####", and I need the ##### number to compare to the total number of records in the sql database.

  • 2 Contributors
  • 1 Reply
  • 156 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

Total number of rows in the database or in one particular table? The rows in a table can be returned with SELECT COUNT(*) FROM table_name.
Once you have loaded a file in a stream you can use the .readLine() function to move through the file. Then just split the string appropriately to extract the number you are after

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.