eWorld eDictionary: How does it Work?

 

Engine Explanation

Engine description and explanation is well documented in an article by Gavi Narra, you can find it on objectgraph website or on codeproject website, if they are broken we host a local copy here.

Changes

eWorld Network's data access is based on a MySQL server, so following editing was required:

[..]
string sql = "SELECT * FROM dictionary_en WHERE word LIKE '" + keyword.Trim().Replace("'","''") + "%' LIMIT 10";
OdbcConnection conn = new OdbcConnection(ConfigurationSettings.AppSettings["SQL_4"]);
conn.Open();
DataTable dt = new DataTable();
OdbcCommand command = new OdbcCommand(sql,conn);
OdbcDataAdapter adapter = new OdbcDataAdapter(command);
[..]