DAL DbConnectionusing System.Configuration;namespace AamirHasan.DAL{ public class DBConnection { public DataACDataContext GetDBContext() { return new DataACDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); } }}
DataAC.dbml
AamirHasan.BLL
ICountry.cs
using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace AamirHasan.BLL{ public class ICountry { private long id; private string name; public long ID { get { return id; } set { id = value; } } public string Name { get { return name; } set { name = value; } } }}
Country.cs
using System;using System.Collections.Generic;using System.Linq;using System.Text;using AamirHasan.DAL;namespace AamirHasan.BLL{ public class Country : ICountry { public List<Country> getAllCountriesName() { DBConnection d = new DBConnection(); using (var db = d.GetDBContext()) { List<Country> _List = (from Obj in db.countries select new Country { ID = Obj.id, Name = Obj.name }).ToList<Country>(); return _List; } } }} <script src="JavaScript/jquery.js" type="text/javascript"></script> <script src="JavaScript/jtemplates.js" type="text/javascript"></script> <link href="CSS/StyleSheet.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> $(document).ready(function() { $.ajax({ type: "POST", url: "Default.aspx/getAllCountriesName", data: "{}", contentType: "application/json; charset=utf-8", dataType: "json", success: (function Success(data, status) { $('#placeholder').setTemplateURL('JTemplates/ForEachTemplate.htm'); $('#placeholder').processTemplate(data.d); }) }); }); </script></head><body> <form id="form1" runat="server"> <p><h1>How to Apply Jtemplate in asp.net using,Linq</h1></p> <p><h4>Author:Aamir Hasan<br />www.aspxtutorial.com<br />092 333 5494532</h4></p> <div id="placeholder" style="clear: both;"></div> </form>
Download
password:aamirhasan