ASP.NET Web Service(returning JSON)

Step 1. Add a Web Service to your project.

Step 2. Add these namespaces to your service

using System.Web.Services;

using System.Web.Script.Services;

using System.Web.Script.Serialization;

Step 3. Create a table in your database as

CREATE TABLE [dbo].[tblStudents](

       [id] [int] IDENTITY(1,1) NOT NULL,

       [name] [nvarchar](100) NULL,

       [gender] [nvarchar](100) NULL,

       [total] [int] NULL

)

Step 4. Add some dummy data to table.

Step 5. Add a class file and create following function in this class

public class student

    {

        public int ID { get; set; }

        public string Name { get; set; }

        public string Gender { get; set; }

        public int Total { get; set; }

    }

Now come back to your web service :

Step 6. I have created a stored procedure to set data from table as

CREATE procedure [dbo].[getstudent]

as

begin

  select id, name, gender, total from tblStudents

end

Step 7. Add following code to create web sevice :

[WebMethod]

        [ScriptMethod(ResponseFormat = ResponseFormat.Json)]

        public string GetEmployessJSON()

        {

            student stu = new student();

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());

            SqlCommand cmd = new SqlCommand("getstudent", con);

            cmd.CommandType = CommandType.StoredProcedure;

            //cmd.Parameters.AddWithValue("@id", ID);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataTable dt = new DataTable();

            da.Fill(dt);

            return new JavaScriptSerializer().Serialize(ss(dt.Rows.Count, dt)); 

        }

        public student[] ss(int s, DataTable dt)

        {

            student[] stu = new student[s];

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                stu[i] = new student();

                stu[i].ID = int.Parse(dt.Rows[i]["id"].ToString());

                stu[i].Name = dt.Rows[i]["name"].ToString();

                stu[i].Gender = dt.Rows[i]["gender"].ToString();

                stu[i].Total = Convert.ToInt32(dt.Rows[i]["total"].ToString());

            }

            return stu;

        }