Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static void ReadOrderData(string connectionString)
- {
- string queryString =
- "SELECT OrderID, CustomerID FROM dbo.Orders;";
- using (SqlConnection connection = new SqlConnection(
- connectionString))
- {
- SqlCommand command = new SqlCommand(
- queryString, connection);
- connection.Open();
- SqlDataReader reader = command.ExecuteReader();
- try
- {
- while (reader.Read())
- {
- Console.WriteLine(String.Format("{0}, {1}",
- reader[0], reader[1]));
- }
- }
- finally
- {
- // Always call Close when done reading.
- reader.Close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement