asp ajax data,Jquery+ajax请求data显示在GridView上(asp.net)

AJAXLoadProgressForm.aspx:

function ShowProgressDiv() {

var ID = $("input#idtxt").val();

$.ajax({

type: "GET",

url: "GetGridViewByConditionForm.aspx",

data: "id=" + ID,

beforeSend: function() {

$("div#ProgressDiv").css("display", "block");

},

success: function(msg) {

$("div#ShowSearchResult").html(msg);

},

complete: function() {

$("div#ProgressDiv").css("display", "none"); ;

}

});

}

LoadingLoading......

GetGridViewByConditionForm.aspx:

protected void Page_Load(object sender, EventArgs e)

{

if (Request["id"] != null)

{

SqlConnection conn=null;

SqlCommand cmd = null;

SqlDataAdapter adapter = null;

try

{

conn = new SqlConnection();

conn.ConnectionString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

conn.Open();

cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandType = CommandType.Text;

String cmdStr = "select * from dbo.Customers";

if (Request["id"].ToString()!=String.Empty)

{

cmdStr += " where CustomerID= '" + Request["id"].ToString() + "'";

}

cmd.CommandText = cmdStr;

adapter = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

adapter.Fill(ds);

this.gvData.DataSource = ds;

this.gvData.DataBind();

}

catch

{

Response.Write("Error happend!");

Response.Flush();

Response.End();

}

finally

{

if (adapter != null)

{

adapter.Dispose();

}

if (cmd != null)

{

cmd.Dispose();

}

if ((conn != null) && (conn.State == ConnectionState.Open))

{

conn.Close();

}

}

}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值