使用Jquery和Webmethod将数据绑定到网格 [英] bind data to grid using Jquery and Webmethod

问题描述

hi
i有：

page.cs：

hi i have :
page.cs :

public class GetName
{
    public string Name { get; set; }
    public string Family { get; set; }
}

[WebMethod]
public List<GetName> LoadName()
{
    SqlConnection connect = objcon.conect();
    List<GetName> GetNameInfoList = new List<GetName>();
    DataSet ds;
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM TblNames ", connect))
    {
        connect.Open();
        cmd.Connection = connect;
        cmd.CommandType = CommandType.Text;
        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
        {

            ds = new DataSet();
            da.Fill(ds);
        }
    }
    try
    {
        if (ds != null)
        {
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        GetNameInfoList.Add(new GetName()
                        {
                            Name = dr["name"].ToString(),
                            Family= dr["family"].ToString()
                        });
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        throw ex;
    }
    return GetNameInfoList;
}

页面aspx：

page aspx:

<script>
    function BindGridView() {
        $.ajax({
            type: "POST",
            url: "Default.aspx/GetNames",
            data: "{}",
            contentType: "application/json",
            dataType: "json",
            success: function (data) {
                for (var i = 0; i < data.d.length; i++) {

                    //How can bind to grid??????????????????????

                }

            }

        })

    }

</script>

<asp:GridView ID="GridView1" runat="server"  AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("Name") %>'></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox2" runat="server" Text='<%#Bind("Family") %>'></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

现在我怎么能将数据绑定到网格????????????????

now i how can bind data to Grid?????????????????

推荐答案

.ajax（{
type：POST，
url：Default.aspx / GetNames，
data：{} ，
contentType：application / json，
dataType：json，
success：function（data）{
for（var i = 0; i < data.d.length; i ++） {

// bind grid ????????????????????

<小号pan class =code-attribute> }

}

< span class =code-attribute>}）

}

< / script >

.ajax({ type: "POST", url: "Default.aspx/GetNames", data: "{}", contentType: "application/json", dataType: "json", success: function (data) { for (var i = 0; i < data.d.length; i++) { //How can bind to grid?????????????????????? } } }) } </script>

< br $>

<asp:GridView ID="GridView1" runat="server"  AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("Name") %>'></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox2" runat="server" Text='<%#Bind("Family") %>'></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

现在我怎么能将数据绑定到网格？ ???????????????

now i how can bind data to Grid?????????????????

check 使用ASP.Net中的jQuery或JSON将数据绑定到GridView [ ^ ]



示例代码：

check Bind data to GridView with jQuery or JSON in ASP.Net[^]

sample code:

public partial class WebForm1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        BindDummyItem();
    }

    private void BindDummyItem()
    {

        DataTable dtGetData = new DataTable();
        dtGetData.Columns.Add("Family");
        dtGetData.Columns.Add("Name");
        dtGetData.Rows.Add();

        grdDemo.DataSource = dtGetData;
        grdDemo.DataBind();
    }
    [WebMethod]
    public static List<GetName> LoadName()
    {
        return new List<GetName>(){new GetName(){ Family ="aaa", Name ="bbbb"},
        new GetName(){ Family ="ccc", Name ="ddd"}};
    }
}

public class GetName
{
    public string Name { get; set; }
    public string Family { get; set; }
}

ASPX

ASPX

<head runat="server">
    <script src="Scripts/jquery-2.1.1.min.js"></script>
    <script type="text/javascript">

（document）.ready（function（）{
BindGridView（）;
}）;
函数BindGridView（）{

(document).ready(function () { BindGridView(); }); function BindGridView() {

这篇关于使用Jquery和Webmethod将数据绑定到网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！