//@SetSearchAutocomplete
public void setSearchAutoCompletion()
{
//@reset
try {
//dr.Close()
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" };
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch);
var da_meb = Module1.getSqlDataAdapter("Select [S_ID] from Sell_BillMember");
DataSet ds_meb = new DataSet();
Module1.ClearTables(ds_meb, "Search_Bill_Member");
da_meb.Fill(ds_meb, "Search_Bill_Member");
if (ds_meb.Tables["Search_Bill_Member"].Rows.Count > 0)
{
for (int i = 0; i <= ds_meb.Tables["Search_Bill_Member"].Rows.Count - 1; i++)
{
AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem();
var dtSet = ds_meb.Tables["Search_Bill_Member"].Rows[i];
itemAuto.Text = dtSet[0].ToString();
itemAuto.ToolTipText = "Search By Sell Package ID " + itemAuto.Text;
itemAuto.ToolTipTitle = "Search A Sell Package By ID";
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto);
}
}
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update();
Module1.ClearReader(ds_meb, da_meb);
} catch (Exception ex) {
}
}
public void setSearchAutoCompletion()
{
//@reset
//dr.Close()
try {
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" };
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch);
var da_meb = Module1.getSqlDataAdapter("Select [MID] , [Licence] , [LicenceName] from Member_Detail");
DataSet ds_meb = new DataSet();
Module1.ClearTables(ds_meb, "Search_members");
da_meb.Fill(ds_meb, "Search_members");
if (ds_meb.Tables["Search_members"].Rows.Count > 0)
{
for (int i = 0; i <= ds_meb.Tables["Search_members"].Rows.Count - 1; i++)
{
AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem();
var dtSet = ds_meb.Tables["Search_members"].Rows[i];
itemAuto.Text = dtSet[0].ToString();
itemAuto.ToolTipText = "Search By ID " + itemAuto.Text;
itemAuto.ToolTipTitle = "Search A Member By ID";
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto);
itemAuto = new AutocompleteMenuNS.AutocompleteItem();
//license
itemAuto.Text = dtSet[1].ToString();
itemAuto.ToolTipText = "Search By Licence " + itemAuto.Text;
itemAuto.ToolTipTitle = "Search A Member By Licence";
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto);
//license name
itemAuto = new AutocompleteMenuNS.AutocompleteItem();
//license
itemAuto.Text = dtSet[2].ToString();
itemAuto.ToolTipText = "Search By LicenceName " + itemAuto.Text;
itemAuto.ToolTipTitle = "Search A Member By LicenceName";
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto);
}
}
My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update();
Module1.ClearReader(ds_meb, da_meb);
} catch (Exception ex) {
}
}
//@SetAutocompletememberID
public void SetAutocompleteMemberID()
{
try {
dap = new SqlDataAdapter("Select MID from Member_Detail", Module1.conn);
dap.Fill(dsM, "Member");
dsM.Tables["Member"].Clear();
dap.Fill(dsM, "Member");
if (dsM.Tables["Member"].Rows.Count > 0)
{
for (int id = 0; id <= dsM.Tables["Member"].Rows.Count - 1; id++)
{
AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem();
itemAuto.Text = dsM.Tables["Member"].Rows[id][0].ToString();
itemAuto.ToolTipText = "Memeber ID " + itemAuto.Text;
itemAuto.ToolTipTitle = "Select A Member ID";
MemberAutoID.AddItem(itemAuto);
}
}
MemberAutoID.Update();
dap.Dispose();
dsM.Dispose();
} catch (Exception ex) {
}
}
