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:

         void AutoComplete(int i)
         {
             AutoCompleteStringCollection auto = new AutoCompleteStringCollection();
             if (i==1)
             {
                 var tbDOCGIA = (
                                 from tb in db.tbDGs
                                 join tbTHE in db.tbThes on tb.MaDG equals tbTHE.MaDG
                                 select tb.TenDG);
                 if (tbDOCGIA!=null)
                 {
                     foreach (var item in tbDOCGIA)
                     {
                         auto.Add(item.Trim());
                     }
                 }
                 txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
                 txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
                 txtSearch.AutoCompleteCustomSource = auto;
             }
             if (i==2)
             {
                 var tbDOCGIA = (
                                 from tb in db.tbDGs
                                 join tbTHE in db.tbThes on tb.MaDG equals tbTHE.MaDG
                                 select tb.MaDG);
                 if (tbDOCGIA != null)
                 {
                     foreach (var item in tbDOCGIA)
                     {
                         auto.Add(item.Trim());
                     }
                 }
                 txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
                 txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
                 txtSearch.AutoCompleteCustomSource = auto;
             }
             if (i==3)
             {
                 var tbDOCGIA = (
                                 from tb in db.tbDGs
                                 join tbTHE in db.tbThes on tb.MaDG equals tbTHE.MaDG
                                 select tbTHE.MaThe);
                 if (tbDOCGIA != null)
                 {
                     foreach (var item in tbDOCGIA)
                     {
                         auto.Add(item.Trim());
                     }
                 }
                 txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
                 txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
                 txtSearch.AutoCompleteCustomSource = auto;
             }
         }