string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"; string query = "SELECT * FROM Employee;"; SqlConnection sqlConn = new SqlConnection(connectionString); SqlCommand sqlCmd = new SqlCommand(query, sqlConn); sqlConn.Open(); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); while (sqlReader.Read()) { Console.WriteLine("ID: {0}, Name: {1}, Age: {2}", sqlReader["ID"], sqlReader["Name"], sqlReader["Age"]); } sqlReader.Close(); sqlConn.Close();
string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"; SqlConnection sqlConn = new SqlConnection(connectionString); SqlCommand sqlCmd = new SqlCommand("myStoredProcedure", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlConn.Open(); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); while (sqlReader.Read()) { Console.WriteLine("ID: {0}, Name: {1}, Age: {2}", sqlReader["ID"], sqlReader["Name"], sqlReader["Age"]); } sqlReader.Close(); sqlConn.Close();Package Library: System.Data.SqlClient is a built-in package library in C#. It is part of the .NET Framework and does not need to be separately installed.