How to get the data from SQL Server in Android

Question

How to get the data from SQL Server in Android-

i have done it via web service using ksoap library or directly with jdbc driver, but in the both cases i am getting 'android.os.networkonmainthreadexception'.

Saineshwar Bageri · Answer

Create a WebService for your data and connect via that web service on your android device. http://www.w3schools.com/webservices/ http://stackoverflow.com/questions/15600906/creating-web-service-for-android-application http://android.programmerguru.com/android-webservice-example/ http://amitku.wordpress.com/2011/08/03/how-to-connect-and-access-sql-database-server-from-android-app/

Venu Saini · Answer

You'll have to move your code to an Async Task inside your activity. class ConnectToDatabase extends AsyncTask { @Override protected void onPreExecute() { super .onPreExecute(); } protected String doInBackground(Void... arg0) { String is = "" ; // YOUR CODE HERE return is; } protected void onPostExecute(String result) { super .onPostExecute(result); } } And then call this in your onCreate method. new ConnectToDatabase().execute(); Refer to this: http://stackoverflow.com/a/6343299/5093327 Can you please post the code on how did you get the data from SQL Server in Android? Thanks.

How to get the data from SQL Server in Android

Answers (2)