Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. private static void ReadOrderData(string connectionString)
  2. {
  3. string queryString =
  4. "SELECT OrderID, CustomerID FROM dbo.Orders;";
  5. using (SqlConnection connection = new SqlConnection(
  6. connectionString))
  7. {
  8. SqlCommand command = new SqlCommand(
  9. queryString, connection);
  10. connection.Open();
  11. SqlDataReader reader = command.ExecuteReader();
  12. try
  13. {
  14. while (reader.Read())
  15. {
  16. Console.WriteLine(String.Format("{0}, {1}",
  17. reader[0], reader[1]));
  18. }
  19. }
  20. finally
  21. {
  22. // Always call Close when done reading.
  23. reader.Close();
  24. }
  25. }
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement