ajax显示数据库asp.net,ajax.net对数据库的插入实例

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 = https://www.jb51.net/wghost/archive/2011/12/01/Request.QueryString["no"].ToString();

SqlDataSource1.InsertParameters["name"].DefaultValue = https://www.jb51.net/wghost/archive/2011/12/01/Request.QueryString["name"].ToString();

SqlDataSource1.Insert();

}

}