Jquery+ajax请求data显示在GridView上(asp.net)_Javascript教程-查字典教程网
Jquery+ajax请求data显示在GridView上(asp.net)
Jquery+ajax请求data显示在GridView上(asp.net)
发布时间:2016-12-30 来源:查字典编辑
摘要:AJAXLoadProgressForm.aspx:复制代码代码如下:functionShowProgressDiv(){varID=$("...

AJAXLoadProgressForm.aspx:

复制代码 代码如下:

<script src="JS/jquery-1.4.2.js" type="text/javascript"></script>

<script type="text/javascript">

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"); ;

}

});

}

</script>

<form id="form1" runat="server">

<div>

<input type="text" id="idtxt" name="idtxt" />

<input type="button" id="LoadBtn" value="LoadDataGridView" />

</div>

<div id="ProgressDiv">

<img alt="Loading" src="Images/ajax-loader.gif" />Loading......

</div>

<div id="ShowSearchResult">

</div>

</form>

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();

}

}

}

}

相关阅读
推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  • 最新Javascript教程学习
    热门Javascript教程学习
    编程开发子分类