Jsgrid: JS GRID on Dynamic data

[Venkatramanaryams]

HELLO,I HAVE FETCHED THE DATA FROM DATABASE USING JAVA AND STORES IT ON JSON ARRAY .NOW I WANT SHOW THE DATA ON JSGRID TABLE PLEASE HELP ON THIS PROBLEM.
THIS IS MY JSGRID CODE

 $("#jsGrid").jsGrid({
         height: "70%",
         width: "100%",
         filtering: true,
    editing: true,
    paging: true,
    pageSize: 15,
    pageButtonCount: 5,
       fields: [
    { name: "Patient ID", type: "text", width: 150 },
    { name: "PatientName", type: "text", width: 150 },
    { name: "visitID", type: "text", width: 150 },
    { name: "Contact no", type: "text", width: 200 },
    { type: "kk" }
    ]
    });
    </script>
THIS IS MY BACKEND CODE
            ResultSet rs = st.executeQuery(query);


            while (rs.next()) {

                  JsonArray row = new JsonArray();
                 row.add(new JsonPrimitive(rs.getString("temp_patient_id")));
                    row.add(new JsonPrimitive(rs.getString("temp_patient_name")));
                    row.add(new JsonPrimitive(rs.getString("temp_gender_id")));
                    row.add(new JsonPrimitive(rs.getString("temp_mobile")));
                    data.add(row);
            }
            jsonResponse.add("ResponseData", data);
                out.println(jsonResponse);

[venkatesh333]

Yes,
I am also having the same problem.
In 1st step we convert Resultset data into Json Object.
can any one explain How we load Json object data into Js grid.

[richraid21]

Per the documentation, you need to provide a data property or controller object to JSGrid

[Venkatramanaryams]

Firstly, Thank you for your response.
controller: {
loadData: function (filter) {
return $.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "/project-name/filename",
data: filter,
dataType: "json"
});
}},
i kept like this but it it is not working properly ,please tell me appropriate solution clearly.
Thanks in Advance

[tanhargithub]

Hi Venkatramanaryams,

The data returned by your ajax call should either be in this format:

[{"Author":"Gambardella, Matthew","Description":"An in-depth look at creating applications with XML.","Genre":"Computer","ID":"bk101","PlotNo":"101","Price":44.95,"Title":"XML Developer's Guide"},{"Author":"Ralls, Kim","Description":"A former architect battles corporate zombies,\u000a an evil sorceress, and her own childhood to become queen\u000a of the world.","Genre":"Fantasy","ID":"bk102","PlotNo":"102","Price":5.95,"Title":"Midnight Rain"}]

If there are any changes in the structure of the data returned by your ajax call, you can form it as object array as shown above on success of the ajax call.

[Venkatramanaryams]

Thanks tanhargithub,
Is that ajax call is wrong?
it is written like that only

[Venkatramanaryams]

thank you i got the grid @tanhargithub @richraid21 @tabalinas