Copying and Pasting cs Code

In cs, like in almost any computer programming language, reading data from a file can be tricky. You add extra lines of code to tell the computer what to do. Sometimes you can copy and paste these lines from other peoples’ code.

For example, you can follow the pattern in this listing:

         private void RoomInfo_Load(object sender, EventArgs e)
         {
             // TODO: This line of code loads data into the 'hospitalDataSet2.room' table. You can move, or remove it, as needed.
             this.roomTableAdapter.Fill(this.hospitalDataSet2.room);
             using (SqlConnection con1 = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\hospital.mdf;Integrated Security=True"))
             {

                 string str2 = "SELECT * FROM room";
                 SqlCommand cmd2 = new SqlCommand(str2, con1);
                 SqlDataAdapter da = new SqlDataAdapter(cmd2);
                 DataTable dt = new DataTable();
                 da.Fill(dt);
                 dataGridView1.DataSource = new BindingSource(dt, null);
             }
         }