public TextBox GetStudent(TextBox myTb)
{
yourString = "Select initcap(last_name) from student order by last_name";
return(query.ViaTextbox_AutoCompleteCustomSource(yourString, myTb));
}
public TextBox GetEmployeeViaAutoComplete(TextBox myTb)
{
myString = "select initcap(member_lname)||', '||initcap(member_fname)||' '||initcap(member_mi) from member_master where member_status = 't' order by member_lname";
return(myQuery.ViaTextbox_AutoCompleteCustomSource(myString, myTb));
}
public TextBox GetProfiles(TextBox myTb)
{
myString = "Select initcap(last_name)||', '||initcap(first_name)||' '||' ' from employee_profiles order by last_name";
return(myQuery.ViaTextbox_AutoCompleteCustomSource(myString, myTb));
}