Step 6: Create an asmx file and create below class.

public class Recipie
{
      public string by;
      public string Recipiename;
      public string preparationtime;
      public string cookingtime;
}

Step 7: Add below name space in the asmx.cs file

using System.Web.Script.Services;
using System.Data;
using System.Data.SqlClient;

Step 8: Create below webmethod in the asmx.cs file to get data from database and return List to jQuery

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
public List<Recipie> GetRecipie()
{
      string strQuery = "SELECT * FROM Recipie";
      DataTable dtRecipie = null;
      Recipie objRecipie;
      SqlConnection con = GetConnection("Data Source=(local);Initial Catalog=DataTable;Integrated Security=SSPI");
      using(con)
      {
            con.Open();
            using (SqlDataAdapter sqlAdapter = new SqlDataAdapter(strQuery, con))
            {
                  dtRecipie = new DataTable();
                  sqlAdapter.Fill(dtRecipie);
            }
      }
      List<Recipie> drlist = new List<Recipie>();
      foreach (DataRow row in dtRecipie.Rows)
      {
            objRecipie = new Recipie();
            objRecipie.by = row["by"].ToString();
            objRecipie.Recipiename = row["Recipiename"].ToString();
            objRecipie.preparationtime = row["preparationtime"].ToString();
            objRecipie.cookingtime = row["cookingtime"].ToString();
            drlist.Add(objRecipie);
      }
      return drlist;
}

Step 9 : Add below method to get SqlConnection

private SqlConnection GetConnection(string m_conString)
{
      SqlConnection con = new SqlConnection(m_conString);
      return con;
}

This ends the article of creating datatable using jquery and webservice.