34 строки
928 B
C#
34 строки
928 B
C#
// <Snippet1>
|
|
using System;
|
|
using System.Data;
|
|
using Microsoft.Data.SqlClient;
|
|
|
|
class Program
|
|
{
|
|
static void Main()
|
|
{
|
|
string str = "Data Source=(local);Initial Catalog=Northwind;"
|
|
+ "Integrated Security=SSPI";
|
|
string qs = "SELECT OrderID, CustomerID FROM dbo.Orders;";
|
|
CreateCommand(qs, str);
|
|
}
|
|
|
|
private static void CreateCommand(string queryString,
|
|
string connectionString)
|
|
{
|
|
using (SqlConnection connection = new SqlConnection(
|
|
connectionString))
|
|
{
|
|
SqlCommand command = new SqlCommand(queryString, connection);
|
|
connection.Open();
|
|
SqlDataReader reader =
|
|
command.ExecuteReader(CommandBehavior.CloseConnection);
|
|
while (reader.Read())
|
|
{
|
|
Console.WriteLine(String.Format("{0}", reader[0]));
|
|
}
|
|
}
|
|
}
|
|
// </Snippet1>
|
|
}
|