public void Connect()
{
Java.Sql.IConnection con = null;
try {
var driver = new Net.Sourceforge.Jtds.Jdbc.Driver();
String username = "******";
String password = "******";
String address = "192.168.1.101";
String port = "1433";
String database = "Database";
String connString = String.Format("jdbc:jtds:sqlserver://{0}:{1}/{2};user={3};password={4}",
address, port, database, username, password);
con = DriverManager.GetConnection(connString, username, password);
IPreparedStatement stmt = null;
try {
//Prepared statement
stmt = con.PrepareStatement("SELECT * FROM Users WHERE Id = ? AND Name = ?");
stmt.SetLong(1, 1);
stmt.SetString(2, "John Doe");
stmt.Execute();
RunOnUiThread(() => Toast.MakeText(this, "SUCCESS!", ToastLength.Short).Show());
IResultSet rs = stmt.ResultSet;
IResultSetMetaData rsmd = rs.MetaData;
PrintColumnTypes.PrintColTypes(rsmd);
Console.WriteLine("");
int numberOfColumns = rsmd.ColumnCount;
for (int i = 1; i <= numberOfColumns; i++)
{
if (i > 1)
{
Console.Write(", ");
}
String columnName = rsmd.GetColumnName(i);
Console.Write(columnName);
}
Console.WriteLine("");
while (rs.Next())
{
for (int i = 1; i <= numberOfColumns; i++)
{
if (i > 1)
{
Console.Write(", ");
}
String columnValue = rs.GetString(i);
Console.Write(columnValue);
}
Console.WriteLine("");
}
stmt.Close();
con.Close();
} catch (Exception e) {
RunOnUiThread(() => Toast.MakeText(this, e.Message, ToastLength.Long).Show());
Console.WriteLine(e.StackTrace);
stmt.Close();
}
con.Close();
} catch (Exception e) {
Console.WriteLine(e.StackTrace);
RunOnUiThread(() => Toast.MakeText(this, e.Message, ToastLength.Long).Show());
}
RunOnUiThread(() => _button.Enabled = true);
}