ajax连接数据库并操作数据库

 Response.Write("<script  type=‘text/javascript‘ language=‘javascript‘ >alert(‘用户名不能为空!请输入!‘)</script>");

---------------------------------------------------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <script type="text/javascript" language="javascript">
        function showCustomer() {
            alert("ddd")
            var str = document.getElementById("txtvalue").value;
            if (str == "") {
                return;
            }
            var xmlhttp;

            if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
                xmlhttp = new XMLHttpRequest();
            }
            else {// code for IE6, IE5
                xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
            }
            xmlhttp.onreadystatechange = function () {
                if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                    document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
                }
            }
            xmlhttp.open("GET", "Conn.aspx?name="+str, true);
            xmlhttp.send();
        }

        function add() {
            var names = document.getElementById("names").value;
            var Valuses = document.getElementById("Valuses").value;
            if (names == "") {
                return;
            }
            if (Valuses == "") {
                return;
            }
            var xmlhttp;
            if (window.XMLHttpRequest) {
              xmlhttp=new XMLHttpRequest();
             }
            else{
                xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
            }
              xmlhttp.onreadystatechange = function () {
                if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                    document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
                }
            }
            xmlhttp.open("POST", "addweb.aspx", true);
              xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
              xmlhttp.send("names=‘" + names + "‘&Valuses=‘" + Valuses + "‘");
        }
    </script>
</head>
<body>
    <input type="button" id="btncoon" value="连接" onclick="showCustomer()" /><br />
    <input type="text" id="txtvalue" />
    <input type="button" id="Button1" value="查询" onclick="showCustomer()" />
    <br />
    <input type="text" id="names" /><input type="text" id="Valuses" />
    <input type="button" id="btnadd" value="添加" onclick="add()" />
    <div id="txtHint">
    </div>
</body>
</html>

------------------------------------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Conn.aspx.cs" Inherits="WebApplication1.Conn" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <%
        string strconn = "Data Source=PC-201001081513;Initial Catalog=WebFirst;Integrated Security=True";
        SqlConnection conn = new SqlConnection(strconn);
        SqlCommand cmd = new SqlCommand();
          if (conn.State == ConnectionState.Closed)
        {
            conn.Open();
        
             
        }
          string ad = Request["name"];
          string sql = "select Name,Valuses,ParentId from DaoHang where name=‘"+ad +"‘";
          cmd.CommandText = sql;
          cmd.Connection = conn;
         // System.Data.DataSet ds = new System.Data.DataSet();
         // System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(cmd);
         // sda.Fill(ds);
         // if (ds.Tables[0].Rows.Count > 0)
          //{
             
         // }
          SqlDataReader ar = cmd.ExecuteReader();
          while (ar.Read())
          {
              Response.Write(ar.GetSqlString(0)+"</br>");
          }
       
         
    %>
  
    </div>
    </form>
</body>
</html>

ajax连接数据库并操作数据库

上一篇:MySQL索引背后的数据结构及算法原理(转)


下一篇:微软推出的免费新书《Introducing Microsoft SQL Server 2012》