public void test() { using (StreamWriter writer = new StreamWriter("C:\\Users\\phil\\Documents\\payroll.txt")) { writer.WriteLine("test2"); SQLConn sql = new SQLConn(); sql.SQLOpen(); SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_Employees_Get_All]", sql.SQLConnReturn()); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { writer.WriteLine(reader["FirstName"]); } } }