retrieve data from sql in HTML5

Question

I have a simple html 5 login page, I need to open a sql connection and have a condition to match the entered details and match or not.

code i have right now is this

Email Address: <input id="Text1" type="text" />

Password: <input id="Password1" type="password" />

<input id="Submit1" type="submit" value="Submit"  onclick="loginFunction()"/> 

<input id="Reset1" type="reset" value="Cancel" />

I have created onclick function. Please help me to open a sql connection and verify the login details

you have to call sql query from any server side code then call that method from jQuery then you can bring the data in jQuery object — wiretext
– wiretext, Commented May 27, 2015 at 11:04
possible duplicate of How to connect to SQL Server database from JavaScript? — Andrey Korneyev
– Andrey Korneyev, Commented May 27, 2015 at 11:05

Diogo Cunha · Accepted Answer · 2015-05-27 11:07:56Z

2

You need a server side to retrieve data.

You have a bunch of databases that you can use.

Going for a mysql database would be a nice approach as it is 100% open source, very simple and it offers stability, if you choose it advice you to choose php for server side, it is old and not very power full but is good for simple pages and for beginners.

If you prefer a NoSQL database you can chose mongoDb for example and (although i have no experience with this) I think that you can link to the database with json

answered May 27, 2015 at 11:07

Diogo Cunha

1,19411 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bhanu.cs · Accepted Answer · 2015-05-27 11:10:59Z

If you are using sql server ms as databse and c# as the server side coding,which i assume you must be using . In the Page Load Or On the Button Click Event Establish a connection string as below.

string connectionString="Data Source=servername;InitialCatalog=DataBaseName;UserID=sa;  Password=YourPassword;"

Now create an Sql Connection object and open the connection

SqlConnection sqlConnection=new SqlConnection(connectionString);
 sqlConnection.open();

Now the database connection is set.If you want to fire any queries now use Sql Command Class.The Parameters of the sqlcommand object are the querystring and connection object.

string insertStatement="INSERT INTO TableName(column1,column2) VALUES Txtb1+","+Txtb2";

SqlCommand sqlCommand=new SqlCommand(insertStatement,sqlConnection);

Collectives™ on Stack Overflow

retrieve data from sql in HTML5

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related