ajax.net对数据库的插入实例

509人浏览 / 0人评论

Default.aspx

    无标题页

       function data_insert()
       {
          var xmlhttp;
          if (window.ActiveXObject) {
              xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
          }
          else if (window.XMLHttpRequest) {
              xmlhttp = new XMLHttpRequest();
          }
          else {
              alert("您的浏览器不支持ajax，请使用其他！");
          }
          xmlhttp.onreadystatechange=function()
          {
               if (xmlhttp.readyState==4 && xmlhttp.status==200)
               {
                    alert("yeah!");
                }
          }
          var no, name;
          no = document.getElementById("TextBox1").value;
          name = document.getElementById("TextBox2").value;
          var url = "Default2.aspx?no=" + no + "&name=" + name;
          xmlhttp.open("get", url, true);
          xmlhttp.send(null);
       }

        号码：

        姓名：

Default.aspx.cs

复制代码代码如下:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //Button1.Attributes.Add("onclick", "date_insert()");
    }

}

Default2.aspx

复制代码代码如下:

    无标题页

                    ConnectionString=""
            DeleteCommand="DELETE FROM [tst] WHERE [no] = @no"
            InsertCommand="INSERT INTO [tst] ([no], [name]) VALUES (@no, @name)"
            SelectCommand="SELECT * FROM [tst]"
            UpdateCommand="UPDATE [tst] SET [name] = @name WHERE [no] = @no">

Default2.aspx.cs

复制代码代码如下:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataSource1.InsertParameters["no"].DefaultValue = //www.jb51.net/wghost/archive/2011/12/01/Request.QueryString["no"].ToString();
        SqlDataSource1.InsertParameters["name"].DefaultValue = //www.jb51.net/wghost/archive/2011/12/01/Request.QueryString["name"].ToString();
        SqlDataSource1.Insert();
    }

}

您可能感兴趣的文章: