JSON CODE USING HANDLER IN .ASHX

  if (strMethodName.Length > 0 && strMethodName.Equals("showmykeyclients"))
        {

            StringBuilder sb = new StringBuilder();
          
          
 
 

            con.Open();
            cmd = new SqlCommand("select dealername,clientname,userid,reqno,emailid,classtype,dateofissue,dateofexp,dateofrenual,keyguid from keyclientstbl", con);
            da = new SqlDataAdapter(cmd);
            ds = new DataSet();
            da.Fill(ds,"keyclientstbl");
          //  sb.Append("({ 'Records':");
                sb.Append("[");
           for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
           {
               sb.Append("{");
               sb.Append("\"dealername\":\"" + ds.Tables[0].Rows[i]["dealername"].ToString() + "\",");
               sb.Append("\"clientname\":\"" + ds.Tables[0].Rows[i]["clientname"].ToString() + "\",");
               sb.Append("\"userid\":\"" + ds.Tables[0].Rows[i]["userid"].ToString() + "\",");
               sb.Append("\"reqno\":\"" + ds.Tables[0].Rows[i]["reqno"].ToString() + "\",");
               sb.Append("\"emailid\":\"" + ds.Tables[0].Rows[i]["emailid"].ToString() + "\",");
               sb.Append("\"classtype\":\"" + ds.Tables[0].Rows[i]["classtype"].ToString() + "\",");
               sb.Append("\"dateofissue\":\"" + ds.Tables[0].Rows[i]["dateofissue"].ToString() + "\",");
               sb.Append("\"dateofexp\":\"" + ds.Tables[0].Rows[i]["dateofexp"].ToString() + "\",");
               sb.Append("\"dateofrenual\":\"" + ds.Tables[0].Rows[i]["dateofrenual"].ToString() + "\",");
               sb.Append("\"keyguid\":\"" + ds.Tables[0].Rows[i]["keyguid"].ToString() + "\"");

               if (i < ds.Tables[0].Rows.Count - 1)
                   sb.Append("},");
               else
                   sb.Append("}");
          
          
           }
          
            con.Close();
            //sb.Append("}");
            sb.Append("]");
           // sb.Append(", 'RecordCount': '1' });');");

            context.Response.Write(sb);
           
        }


 CLINTSIDE CODE
----------------------------
  function showmyclients() {


             var tbl = "";
             tbl += "<table border='1' width='100%'  style='border-collapse:collapse;'>";
             tbl +="<tr><th>dealername</th><th>clientname</th><th>userid</th><th>reqno</th><th>emailid</th><th>classtype</th><th>dateofissue</th><th>dateofexp</th><th>dateofrenual</th></tr>";
             $.ajax({

                 url: "Handler.ashx?StrMethodName=showmykeyclients",
                 type: "Json",
                 cache: false,
                 dataType: "json",
                 data: '{}',
                 success: function (json) {
                     //alert(msg + 'ravi');
                     //  alert(json);


                     for (var i = 0; i < json.length; i++) {

                         if (i % 2 == 0) {

                             tbl += "<tr class='even'><td>" + json[i].dealername + "</td><td>" + json[i].clientname + "</td><td>" + json[i].userid + "</td><td>" + json[i].reqno + "</td><td>" + json[i].emailid + "</td><td>" + json[i].classtype + "</td><td>" + json[i].dateofissue + "</td><td>" + json[i].dateofexp + "</td><td>" + json[i].dateofrenual + "</td></tr>";
                         }
                         else {

                             tbl += "<tr class='odd'><td>" + json[i].dealername + "</td><td>" + json[i].clientname + "</td><td>" + json[i].userid + "</td><td>" + json[i].reqno + "</td><td>" + json[i].emailid + "</td><td>" + json[i].classtype + "</td><td>" + json[i].dateofissue + "</td><td>" + json[i].dateofexp + "</td><td>" + json[i].dateofrenual + "</td></tr>";
                         }

                         //alert(json[i].dealername);
                     }
                     tbl += "</table>";
                     $("#infodiv").html(tbl);

                 },
                 Error: function (msg) {


                     //  alert(msg + 'varma');


                 }
             });
        
        
         }

Reply to: Reply to Ravi Varma

Send