private void SearchSkill()
{
DAL dal = new DAL();
/*for (int i = SkillCollection.Count - 1; i >= 0; i--)
* {
*
* SkillCollection.RemoveAt(i);
*
* }*/
SkillCollection.Clear();
DataTable dt = dal.Read("Select * from bit_skill WHERE (STATUS='ACTIVE' OR STATUS IS NULL) and " + SelectedSkillCols + " like '%" + SkillSearchString + "%'");
int i = 0;
int index = 0;
Skill skillFirstRecord = new Skill();
foreach (DataRow dr in dt.Rows)
{
index = i;
if (index == 0)
{
skillFirstRecord = new Skill(dr);
}
Skill skill = new Skill(dr);
SkillCollection.Add(skill);
i++;
}
SelectedSkill = skillFirstRecord;
//MessageBox.Show(SelectedSkillCols + SkillSearchString);
}
