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.