public static void SearchByMeaning(ListViewEx lvw, String m_TenHocSinh)
{
DictionaryData data = new DictionaryData();
DataTable table = data.SearchByMeaning(m_TenHocSinh);
lvw.Items.Clear();
foreach (DataRow row in table.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["Word"].ToString());
item.SubItems.Add(row["Meaning"].ToString());
lvw.Items.Add(item);
}
}
public static void SearchByWord(ListView lvw, String m_Word)
{
DictionaryData data = new DictionaryData();
DataTable table= data.SearchByWord(m_Word);
lvw.Items.Clear();
foreach (DataRow row in table.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["Word"].ToString());
item.SubItems.Add(row["Meanings"].ToString());
item.SubItems.Add(row["Phonetic"].ToString());
lvw.Items.Add(item);
}
}
public static String SearchByWordExtractMatch(ListView lvw, String m_Word)
{
String meaning = "";
DictionaryData data = new DictionaryData();
DataTable table = data.SearchByWordExtractMatch(m_Word);
lvw.Items.Clear();
if(table.Rows.Count ==1)
{
foreach (DataRow row in table.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["Word"].ToString());
item.SubItems.Add(row["Meanings"].ToString());
item.SubItems.Add(row["Phonetic"].ToString());
lvw.Items.Add(item);
meaning = row["Meanings"].ToString().Trim();
meaning = meaning.Replace("\\n", "\n");
}
}
return meaning;
}