private DataTable GetData(char[] queryItem)
{
DataTable dt = new DataTable();
SqlDataAdapter MainAdapter;
DataSet MainDataSet = new DataSet();
MainAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT " +
"ID, Email, FirstName, LastName, City, State, Country, PrimaryTelephone, EveningTelephone, MobileTelephone, Website, " +
"CompanyName FROM Users_Backup WHERE (ID <> 1) AND " +
"lastname like '[" + queryItem[0] + "-" + queryItem[1] + "]%' order by lastname",
SqlDbType.Int);
MainAdapter.Fill(MainDataSet, "Users_Backup");
dt = MainDataSet.Tables[0];
return(dt);
}
