使用Jquery绑定数据库数据到Gridview

本文关键字：Gridview 数据 数据库 Jquery 绑定 使用 | 更新日期: 2023-09-27 18:07:55

我使用Jquery将数据绑定到Gridview，在复选框上选择更改我从数据库中获取数据，当我尝试将这些数据传递给Jquery以绑定Gridview显示Error时。

Jquery

 <script type="text/javascript">
     $(document).on('click', 'input', function () {
         var key = $(this).find('lb' + this.id).text();
         var val = 'lb' + this.id;
         var lbltext = document.getElementById(val).innerHTML;
         $.ajax({
             type: "POST",
             url: "CandidateManagement.aspx/BindDatatable",
             data: '{value: "' + lbltext + '" }',
             contentType: "application/json; charset=utf-8",
             dataType: "json",
             success: function (details) {
                 alert(response.d.length);
                 for (var i = 0; i < response.d.length; i++) {
                     $("#gvUserManage").append("<tr><td>" + response.d[i].CandidateID + "</td><td>" + response.d[i].CandidateName + "</td><td>" + data.d[i].CurPosition + "</td></tr>" + "<tr><td>" + response.d[i].TotWorkExp + "</td><td>" + response.d[i].Skillset + "</td><td>" + data.d[i].USStatus + "</td></tr>" + "</td><td>" + data.d[i].Location + "</td></tr>" + "</td><td>" + data.d[i].ActiveResume + "</td></tr>");
                 }
             },
             error: function (result) {
                 alert("Error");
             }
         });
</script>

aspx.cs 

[WebMethod]
    public static Admin_CandidateManagement[] BindDatatable(string value)
    {
        string year = value.Substring(0, 2);
        int yearvalue = int.Parse(year);
        Admin_CandidateManagement admincandi = new Admin_CandidateManagement();
        string strSrcQry = admincandi.getSrcQryExpr(yearvalue);

        DataTable dt = new DataTable();
        Recruitment recOBJ = new Recruitment();
        admincandi.recOBJ.GetAllCandiDeatForAdvaceSearch(ref admincandi.dsCandiDeat, strSrcQry);
        //recOBJ.BindData(strSrcQry);
        dt = admincandi.dsCandiDeat.Tables[0];
        List<Admin_CandidateManagement> details = new List<Admin_CandidateManagement>();
        foreach (DataRow dtrow in dt.Rows)
        {
            Admin_CandidateManagement user = new Admin_CandidateManagement();
            user.CandidateID = dtrow["CandidateId"].ToString();
            user.CandidateName = dtrow["CandiName"].ToString();
            user.CurPosition = dtrow["CurrPosi"].ToString();
            user.TotWorkExp = dtrow["TotWrkExp"].ToString();
            user.Skillset = dtrow["SkillSet"].ToString();
            user.USStatus = dtrow["USStatus"].ToString();
            user.Location = dtrow["Location"].ToString() + "   " + dtrow["JobZipCode"].ToString();
            user.ActiveResume = dtrow["ActiveResume"].ToString();
            details.Add(user);
        }
      return details.ToArray();
    }

使用Jquery绑定数据库数据到Gridview

在你的jquery中，这里是'response'，你必须在success函数中写response而不是details 

success: function (response) {
             alert(response.d.length);
             for (var i = 0; i < response.d.length; i++) {
          $("#gvUserManage").append("<tr><td>" + response.d[i].CandidateID + "</td>   <td>" + response.d[i].CandidateName + "</td><td>" + .d[i].CurPosition + "</td></tr>" + "<tr><td>" + response.d[i].TotWorkExp + "</td><td>" + response.d[i].Skillset + "</td><td>" + response.d[i].USStatus + "</td></tr>" + "</td><td>" + response.d[i].Location + "</td></tr>" + "</td><td>" + response.d[i].ActiveResume + "</td></tr>");
             }
         },
相关文章：