How to use WEBSITE X5 to access Microsoft SQL Databases 
Autor: Monty W.
Visited 780,
Followers 2,
Udostępniony 0
Hi there... very new to using Website X5. I'm new to developing website but have skills with Microsoft SQL Server environment. I've downloaded the DEMO version which have no access to the database viewer. I was wondering if anyone can provide me with sample HTML code to access data on a SQL Server.
I am trying to build a timesheet form, bring back info from the SQL server, ie. Dropdown list of all employees. The user will select the employee, on another field, enter their time. Submit button will write the employee name and time to a SQL database.
Not sure how to do this using website X5, unsure if this is the best tool for this purpose.
Would love to hear from you on your experience with SQL server. Thanks for your ideas.
Posted on the
Hello Monty
X5 is not a database tool.
It has a database viewer, but this operates on a MySql database.
X5 is great for building websites.
There is an excellent tool for creating even advanced database application in few hours - the AppGini. But this also functions om MySql database and produces php-code ( this is the normal )
You could use the X5 for building the site and AppGini for building databases.
You can see an example here : http://eksempelsite.dk/side-4.html
It is a simple site and a simple database.
The site built with X5 took few minutes to produce. The content filled in, took some longer time.
Such a database can be built within an hour - again - the database took about an hour to develop, but the data filled in, took some longer time, even if imported. The data is "washed" and the links is cobstructed.
The searching and filtering and other things is automatic generated by the database-tool.
I have worked a lot with ms sql databases, but only with MySql regarding web-applications.
You should consider MySql.
Kind regards
John S.
caspio bridge is also an excellent tool - drop html links from it into x5 - forms, reports, etc linked to your db.