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 AutoCompleteChuyenNganh(int i)
{
AutoCompleteStringCollection auto = new AutoCompleteStringCollection();
auto.Clear();
if (i == 0)
{
var tbDS = (from tb in db.tbDauSaches select tb.ChuyenNganh);
if (tbDS != null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==1)
{
var tbDS = (from tb in db.tbDauSaches select tb.TenSach);
if (tbDS!=null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==2)
{
var tbDS = (from tb in db.tbDauSaches
join tbtg in db.tbTGs on tb.MaTG equals tbtg.MaTG
select tbtg.TenTG);
if (tbDS !=null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==3)
{
var tbDS = (from tb in db.tbDauSaches
join tbnxb in db.tbNXBs
on tb.MaNXB equals tbnxb.MaNXB
select tbnxb.TenNXB);
if (tbDS != null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
}
{
AutoCompleteStringCollection auto = new AutoCompleteStringCollection();
auto.Clear();
if (i == 0)
{
var tbDS = (from tb in db.tbDauSaches select tb.ChuyenNganh);
if (tbDS != null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==1)
{
var tbDS = (from tb in db.tbDauSaches select tb.TenSach);
if (tbDS!=null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==2)
{
var tbDS = (from tb in db.tbDauSaches
join tbtg in db.tbTGs on tb.MaTG equals tbtg.MaTG
select tbtg.TenTG);
if (tbDS !=null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
if (i==3)
{
var tbDS = (from tb in db.tbDauSaches
join tbnxb in db.tbNXBs
on tb.MaNXB equals tbnxb.MaNXB
select tbnxb.TenNXB);
if (tbDS != null)
{
foreach (var item in tbDS)
{
auto.Add(item.Trim());
}
}
txtSearch.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = auto;
}
}