Click here to Skip to main content
15,886,026 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi All,

i am using HTML page,java script and SQLServer2008.

i want to create connection string from sql2008 through JQuery.
how to create code for check user name and password in HTML page using sql2008 and JQuery.

any suggestion or helpful link . . .

Regard

Mukesh
Posted
Updated 18-May-13 1:21am
v3
Comments
Zoltán Zörgő 18-May-13 7:29am    
Not clear. It is an application with just html code, jquery and an sql server as backend? No asp.net, php, asp classic, ruby, python or anything else as application in between? Really?
Well interesting approach...

You can'nt connect your html website using Javascript.
because it is client side scripting language.It can be used only for the interfaces and validations basically.
You should use ASP.net,JSP or Php for connection with SQL Server database.
you can check for
ASP.Net connection
 
Share this answer
 
You have to perform ajax calls (client side) through jquery and json and may be use handler files also to achieve what you want.

I suggest you go thru the below links:

What is jquery ajax: http://api.jquery.com/jQuery.ajax/[^]

5 Ways to Make Ajax Calls with jQuery: http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-calls-with-jquery/[^]

http://www.html.net/tutorials/javascript/lesson21.php[^]


Hope this helps you, if any queries plz let me know.
 
Share this answer
 
v2
This is the Sample Code using HTML & JQuery:

<html> 
    <head>
        <meta charset="utf-8">
        <title>jQuery Validation Plugin Examples</title>

        <!-- Bootstrap CSS used for styling the demo pages-->
        <link rel="stylesheet" href="css/bootstrap.min.css">
        <link rel="stylesheet" href="css/style.css">
    </link></link></meta></head>

    <body>
        <!-- basic validation of a login form -->
        <form class="form" id="example1">
            <div class="form-group">
                <label>Basic login form example</label>
            </div>
            <div class="form-group">
                <label for="example1-email">Email address</label>
                <input type="email" class="form-control" id="example1-email" name="example1-email" placeholder="Enter email">
            </input></div>
            <div class="form-group">
                <label for="example1-password">Password</label>
                <input type="password" class="form-control" id="example1-password" name="example1-password" placeholder="Password">
            </input></div>
            <button type="submit" class="btn btn-primary">Submit</button>
        </form>

        <!-- Load jQuery and jQuery-Validate scripts -->
        <script src="js/jquery.js"></script>
        <script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
        <script>
            // When the document is ready
            $(document).ready(function () {
                
                
                //validation rules
                //by default it will append a <label class="error> element to the invalid input<br mode=" hold=" />                //and will add a " error=" class to the input<br mode=" example1-email=": {<br mode=" example1-password=": {<br mode="></label></script></body></html>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900