public partial class Form1 : Form
    {
        SqlConnection cnn;

        public Form1()
        {
            InitializeComponent();
            cnn = new SqlConnection("Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\course.mdf;Integrated Security=True;Connect Timeout=30");//@"Data Source=localhost; Initial Catalog = course; Integrated Security=SSPI;");
        }

        private void btnConnect_Click(object sender, EventArgs e)
        {
            DataSet dataSet = new DataSet();
            SqlCommand sqlCommand = new SqlCommand("exec SP_InsertBook" +
                                                   "@NameBook='книга 3'," +
                                                   "@Genre='история'," +
                                                   "@AuthorName='Василь'," +
                                                   "@AuthorSurname='Васильович'");
            /* SqlParameter bookName = new SqlParameter("@NameBook",SqlDbType.VarChar);
             SqlParameter genre = new SqlParameter("@NameGenre",SqlDbType.VarChar);
             SqlParameter authorName = new SqlParameter("@AuthorName", SqlDbType.VarChar);
             SqlParameter authorSurname = new SqlParameter("@AuthorSurname", SqlDbType.VarChar);
             bookName.Value = "книга 3";
             genre.Value = "история";
             authorName.Value = "Васька";
             authorSurname.Value = "Васильович";
             sqlCommand.Parameters.Add(bookName);
             sqlCommand.Parameters.Add(genre);
             sqlCommand.Parameters.Add(authorName);
             sqlCommand.Parameters.Add(authorSurname);*/
            cnn.Open();
            sqlCommand.ExecuteNonQuery();
            cnn.Close();
            this.authorsTableAdapter.Fill(this.courseDataSet.Authors);
        }