Android Question MSSQL

Discussion in 'Android Questions' started by Mauricio Hamak, Apr 23, 2019.

  1. Mauricio Hamak

    Mauricio Hamak Member Licensed User

    Hello

    sql1.OpenConnection("jdbc:jtds:sqlserver://xxx.ddns.net/LaGranja;instance_name=SQLSERVER;user=sa;password=xxx;")
    ' read columns
    Dim res As MSSQLResultSet = sql1.ExecuteQuery("SELECT TOP 30 idProducto, Nombre 'Descripcion', PrecioContado FROM productos where Nombre <> 'MODIFICAR' ORDER BY Nombre")
    Do While res.MoveNext
    '
    lstProductos.AddTwoLines2(res.GetInt(1), res.GetString(2) & " $" & NumberFormat2(res.GetDouble(3), 0, 3, 2, True), res.GetInt(1) & "~" & res.GetString(2) & " $" & NumberFormat2(res.GetDouble(3), 0, 3, 2, True))
    Loop

    I have these code but olny works in Debug Mode. I use the LIBRARY MSSQL
     
  2. Erel

    Erel Administrator Staff Member Licensed User

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice