How to bind data in Repeater in Json

Question

Hi,

Referring to the below codes, I'm getting values properly, but can't bind values in Repeater, Where is the problem? how to fix it.

Aspx.VB Page

sCmd.Parameters.Add(param)
            dtadp.Fill(dtset)
            If sCmd.Parameters("@o_ErrorStatus").Value = 1 Then
                f_retval = dtset.Tables(0)
            ElseIf sCmd.Parameters("@o_ErrorStatus").Value = 0 Then
                f_retval = New DataTable()
            End If
        Catch ex As Exception
            f_retval = dtset.Tables(0)
        Finally
            sCon.Close()
        End Try
        Return JsonConvert.SerializeObject(f_retval)

-------------------
Aspx page

$.ajax({
                type: "POST",
                url: "QueryList.aspx/getQryInfo",
                data: '{fGet: ' + JSON.stringify(fGet) + '}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (response) {
                    var result = JSON.parse(response.d);
                    $.each(result, function (i, item) {
                        var hoquery = item.HOQueries;
                        var branchreply = item.BranchResponse;
                      $('#rptUserinfo').append('' + hoquery + '' + branchreply + '');
                    });
                },
                error: function (data, ex) {
      
---------------

Repeater 


                                                            
                                                                
                                                                
                                                                
                                                                    
                                                                        HO Query
                                                                        BranchReply
                                                                    
                                                            
                                                            
                                                                    <%#Eval("hoquery") %>
                                                                    <%#Eval("branchreply") %>

Answer

Hi @Aypn CNN,

You need to put the Repeater control inside an HTML DIV because the Repeater control doesn't render itself, so you can't access it via JavaScript or jQuery using the client ID.

Here is the changed code:


            
              //.......

$('#dvTests table').append('' + hoquery + '' + branchreply + '');

You also need to make sure you get the correct json, which you can check with alert(result);

The following is an example of my test using test data, you can refer to:



    
    
    


    
        
            
                
                    
                    
                    
                        
                            HO Query
                            BranchReply
                        
                
                
                        <%#Eval("HOQueries") %>
                        <%#Eval("BranchResponse") %>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim tests As List(Of Test) = New List(Of Test)()
        tests.Add(New Test())
        rptUserinfo.DataSource = tests
        rptUserinfo.DataBind()

    End Sub

    
    Public Shared Function getQryInfo() As String
        Dim p As List(Of Test) = New List(Of Test)()
        Dim p1 As Test = New Test()
        p1.Id = "1"
        p1.HOQueries = "a"
        p1.BranchResponse = "a"
        Dim p2 As Test = New Test()
        p2.Id = "2"
        p2.HOQueries = "b"
        p2.BranchResponse = "b"
        p.Add(p1)
        p.Add(p2)
        Dim json As String = JsonConvert.SerializeObject(p)
        Return json
    End Function
    Public Class Test
        Public Property Id As String
        Public Property HOQueries As String
        Public Property BranchResponse As String
    End Class

User's image

Best regards,

Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

How to bind data in Repeater in Json

1 answer

Your answer