Can I connect to MS SQL using HTML & JavaScript?
-
Hello there, I would like to know if I can use HTML & JavaScript to connect and manipulate MS SQL
.
If you know of any web pages that describes/teaches how to do that well be great.
In other words, I would like to use Visual Studio to create an ASP.Net C# website but not use C# but rather pure html and JavaScript to connect and modify a MS SQL database, or MS SQL Express or MS SQL Compact.
I would greatly appreciate help on this subject.
Michael N wishes you a great day
-
Hello there, I would like to know if I can use HTML & JavaScript to connect and manipulate MS SQL
.
If you know of any web pages that describes/teaches how to do that well be great.
In other words, I would like to use Visual Studio to create an ASP.Net C# website but not use C# but rather pure html and JavaScript to connect and modify a MS SQL database, or MS SQL Express or MS SQL Compact.
I would greatly appreciate help on this subject.
Michael N wishes you a great day
You can do using activex data objects quite easily. However, if you don't have activex access, this would not work - http://sirlagz.net/2011/07/02/connecting-to-sql-server-with-javascript/[^].
Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial
-
Hello there, I would like to know if I can use HTML & JavaScript to connect and manipulate MS SQL
.
If you know of any web pages that describes/teaches how to do that well be great.
In other words, I would like to use Visual Studio to create an ASP.Net C# website but not use C# but rather pure html and JavaScript to connect and modify a MS SQL database, or MS SQL Express or MS SQL Compact.
I would greatly appreciate help on this subject.
Michael N wishes you a great day
-
Hello there, I would like to know if I can use HTML & JavaScript to connect and manipulate MS SQL
.
If you know of any web pages that describes/teaches how to do that well be great.
In other words, I would like to use Visual Studio to create an ASP.Net C# website but not use C# but rather pure html and JavaScript to connect and modify a MS SQL database, or MS SQL Express or MS SQL Compact.
I would greatly appreciate help on this subject.
Michael N wishes you a great day
No, you cannot. Let me explain. A web application is unlike any client applications. There is this separation of concerns that is called n-tier architecture which consists of client tier (HTML, JavaScript) , server tier (PHP, ASP), and data tier (MSSQL, MySQL). In a typical scenario, when you want to request information from a database, the request is usually submitted through a HTML form and forwarded to a server-side script, say login.php which in turn validates the content of your submission and if valid, this script will connect to the database and retrieve the information using SQL, and lastly, it will formulate the response in HTML format and send back to the browser for display. Fundamentally, web applications created in ASP.NET is no different from what I describe above. However, ASP.NET uses server controls that abstracts the creation of HTML contents and the interaction between browsers and servers. In this way, you can use server controls to create web application the way that you used to work with controls in a client application without thinking about the separation of concerns.