I have to take data from ms sqlserver with the android. Help me please
<pre><code>Connection conn = null;
    String url = "jdbc:jtds:sqlserver://192.168.1.25:1433/";
    String dbName = "Demo;Instance=MSSQLSERVER;";
    String userName = "BIT"; 
    String password = "1234";
    String driver = "net.sourceforge.jtds.jdbc.Driver";

    try {
      TextView  tv1 = (TextView) findViewById(R.id.textView1);
      TextView  tv2 = (TextView) findViewById(R.id.textView2);
      TextView  tv3 = (TextView) findViewById(R.id.textView3);
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT ItemDesc,Qty,NetPrice FROM TrxDetail ");

      while (rs.next()) 
      {
     tv1.setText(rs.getString("ItemDesc"));
     tv2.setText(rs.getString("Qty"));
     tv3.setText(rs.getString("NetPrice"));
     }

      conn.close();
      } catch (Exception e) {
     TextView  tv = (TextView) findViewById(R.id.textView1);
     tv.setText(e.toString());
      } 
</code></pre>

<p>Of this code, I have the last value in the database.
Do the data show all.
I used jtds1.2.5 .
Please help me.
Programmer Thailand (T.T)</p>
