文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>Jquery ajax请求data显示在GridView上

Jquery ajax请求data显示在GridView上

时间:2010-08-27  来源:chenping2008

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" onclick="ShowProgressDiv()" />
    </div>
    <div id="ProgressDiv" style="display:none">
        <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();
                    }
                }
            }
        }
相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载