Android Debug Record 2

----------------

SQL error

Using such a statement in WebService causes an error (because you want to use the Copimporttime column later):

String scourtname = mydatatable.rows[i]["COPZDMC"]. ToString ();

string sSQL = String. Format ("Select top 1 copcgl,convert (varchar), Copimporttime, Max) from Tc_copyrate where copzdmc= ' {0} ' ORDER by Copimp Orttime desc ", scourtname);

Be correct after the following changes:

String scourtname = mydatatable.rows[i]["COPZDMC"]. ToString ();

string sSQL = String. Format ("Select top 1 copcgl,convert (varchar), Copimporttime, Max) as Copimporttime from Tc_copyrate where copzdmc= ' {0} ' ORDER BY copimporttime Desc ', scourtname);

Android Debug Record 2