Connect MS SQL Server with Android Studio All Steps | ProgrammingGeek

It's very easy to connect ms sql server database with android studio if you follow all the steps. We usually use desktop application and need to see summary result in android application. In that case it’s very important to extract live data from sql server database to android app.
To perform this task we need to connect ms sql server with android studio. To practice this tutorial you should have installed java, android studio and sql server.

Steps are
1. Create and design android app
2. Create ms sql server database table and insert records.
3. Add java class to connect ms sql with android studio.
4. Write code in MainActivity. java to display result.
5. Add Jar Dependency in your project library.
6. Add permission in AndroidManifest xml file.
7. Run the app.

Note:
You must have enabled TCP IP in SQL Server if TCP IP is being disabled then restart SQL Server Service.

download and install android studio JDK and SDK
https://youtu.be/g7lUIxVHTec

Connection con;

@SuppressLint("NewApi")
public Connection conclass() {
String ip = "172.1.2.2", port = "1433", db = "mytestdb", username = "sa", password = "yourpass";
StrictMode.ThreadPolicy a = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(a);
String connectURL = null;

try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
connectURL = "jdbc:jtds:sqlserver://" + ip + ":" + port + ";databasename=" + db + ";user=" + username + ";"+"password=" + password + ";";
con = DriverManager.getConnection(connectURL);
} catch (Exception e) {
Log.e("Error :", e.getMessage());
}
return con;
}

------
This channel covers all the programming tutorial related with .Net- C#, linq, VB, SQL, Android, HTML, CSS, jQuery, Crystal Report and Microsoft Report.
So, Please subscribe and keep in touch.
https://www.youtube.com/c/ProgrammingGeek

Visit my page in Facebook
https://www.facebook.com/programminggeek7
------

More Tags
#ConnectMSSQLServerwithAndroidStudio #ConnectAndroidStudiowithSQLServerDatabase #SQLToAndroidStudio

programminggeek,connect android studio with sql server,how to connect android studio with sql server database,connect android studio to database,connect sql database to android studio,connect sql to android studio,connect android studio to sql server,how to connect sql to android studio,connect ms sql server with android studio