using System;
using System.Data;
using System.Data.SqlClient;

public class Starter
{
	public static void Main()
	{
		string conntext= "Initial Catalog=pubs;"
			+"Data Source=localhost;"
			+"Integrated Security=SSPI;";
    		SqlConnection conn= new SqlConnection(conntext);
		SqlCommand command=new SqlCommand("SELECT au_lname, au_fname FROM authors", conn);
		SqlDataAdapter da= new SqlDataAdapter(command);
		
		DataSet ds=new DataSet();
		da.Fill(ds);
		DataTable dt=ds.Tables[0];
		foreach(DataRow row in dt.Rows)
		{
         		Console.WriteLine(row["au_lname"]+", "+row["au_fname"]);
		}

		conn.Close();
	}
}