using System.Data.SqlClient; string connectionString = "Data Source=myServer;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword"; SqlConnection connection = new SqlConnection(connectionString); connection.Open();
string query = "SELECT * FROM Customers"; SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(String.Format("{0} {1}", reader["FirstName"], reader["LastName"])); }
string query = "SELECT * FROM Customers WHERE CustomerID = @CustomerID"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@CustomerID", 12345); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(String.Format("{0} {1}", reader["FirstName"], reader["LastName"])); }These examples use the System.Data.SqlClient package library, which is included with the .NET Framework.