how to display data from a SQL Server query into android tables -

how to display data from a SQL Server query into android tables -

i create connection external server sql server, can display info next code:

void cursorset (){ java.sql.databasemetadata dm = null; seek { connection = this.getconnection(); if (connection != null) { resultset = result; private final string statement = "select*from *******"; dm = connection.getmetadata(); statement select = connection.createstatement(); result = select.executequery(statement); while (result.next()) { mostrar_datos.append("" +result.getobject(1)+result.getobject(2)+" "+result.getobject(3)); } result.close(); result = null; closeconnection(); } else { mostrar_datos.append("error: no active connection"); } } grab (exception e) { e.printstacktrace(); } dm = null; }

the problem need display returned data, on tables dynamic rows , columns, or alertdialog , have no thought how it.

how display info sql server query android tables

so should create class(es) interprets table(s) in real database , method described above should homecoming list of values.

subsequently, returned info can simple display in alertdialog or listview.

example:

your database has 1 table: user 3 columns - id(primary key), name, surname. create class "same structure"

public class user { private int id; private string name; private string surname; // getters , setters }

then method can looks this:

public list<user> getall() { list<user> users = new arraylist<user>(); user u = null; // initialise connection etc. while (resultset.next()) { u = new user(); u.setid(resultset.getint(1)); u.setname(resultset.getstring(2)); u.setsurname(resultset.getstring(3)); users.add(u); } homecoming users; // in block close connection. }

android sql table