Advertisement
Guest User

Untitled

a guest
Nov 12th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Aufgabe 9
  2. private static void ReadOrderData(string connectionString)
  3. {
  4. string queryString =
  5. "SELECT OrderID, CustomerID FROM dbo.Orders;";
  6. using (SqlConnection connection = new SqlConnection(
  7. connectionString))
  8. {
  9. SqlCommand command = new SqlCommand(
  10. queryString, connection);
  11. connection.Open();
  12. using(SqlDataReader reader = command.ExecuteReader())
  13. {
  14. while (reader.Read())
  15. {
  16. Console.WriteLine(String.Format("{0}, {1}",
  17. reader[0], reader[1]));
  18. }
  19. }
  20. }
  21. }private static void ReadOrderData(string connectionString)
  22. {
  23. string queryString =
  24. "SELECT OrderID, CustomerID FROM dbo.Orders;";
  25. using (SqlConnection connection = new SqlConnection(
  26. connectionString))
  27. {
  28. SqlCommand command = new SqlCommand(
  29. queryString, connection);
  30. connection.Open();
  31. using(SqlDataReader reader = command.ExecuteReader())
  32. {
  33. while (reader.Read())
  34. {
  35. Console.WriteLine(String.Format("{0}, {1}",
  36. reader[0], reader[1]));
  37. }
  38. }
  39. }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement