private void Form1_Load(object sender, EventArgs e)
        {
 
            string connectionString = GetConnectionString();
            SqlConnection con = new SqlConnection(connectionString);
            string sqlSelect = "Select * from authors";
            SqlCommand cmd = new SqlCommand(sqlSelect,con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            dataGridView1.DataSource = dt;
 
        }  
 
        static private string GetConnectionString()
        {
            return "Data Source=localhost ; Initial Catalog = pubs;" + "Integrated Security=SSPI ";
        }