Android Question How to Use WebView With MSSQL Library Connection

[Devendra]

Dear All,

Please give me a explanation of how to use the WEBVIEW with MSSQL Connection Library,
I am using the connection and getting the data, I want to display a data set based on a selection in a web view

Devendra

 

[DonManfred]

A Webview cannot have a connection to a Database. It´s your app which do connect to the db and can retrieve data.
You need to create html-page which shows the data based on the database-results. And then let the webview show this htmlpage for you

 

[Devendra]

ok but how to use webview to display the MSSQL output

 

[DonManfred]

ok but how to use webview to display the MSSQL output

Like i already said: create an html-page and show this html inside the webview.

 

[Devendra]

ok sorry to bother you, Can you explain how to create a HTML page using MSSQL i an new to B4A

 

[DonManfred]

to create a HTML page using MSSQL

I dont know which library you exactly using. I dont know one with this name

Anyway: probably all libraries which does any databaseconnection DON´T have any methods to create html. This is YOUR job. Learn html will help here.

new to B4A

LOOOOL.

Member Since:
Mar 15, 2013

 

[Devendra]

i was not active, but i have used this with jason and all but not with MSSQL linrart I am new to this

 

[DonManfred]

There is NO Library with the name MSSQL!!

MSSQL ist the name of the SQL Database from Microsoft (msSQL)

Again:

I dont know which library you exactly using. I dont know one with this name

 

[Devendra]

correct i am connecting to a Microsoft SQL Server 2012 R2,

MSSQL Linrary Version 1.01

This library directly connects with the SQL Server

 

[DonManfred]

Then i suggest to look inside the documentation or the library-methods if there is something to create HTML-Code. But i guess there is no such method.
A SQL Connector Library is not supposed to create html. It is supposed to connect to the Database and retrieve data.

It´s up to YOU to create a html-page from the results if you want to use a Webview for showing them.

 

[Devendra]

Ok i understand you, Mean use the List to populate the HTML Page is it