Saturday, 3 August 2013

Executing SQL Query Using LINQ to SQL,Directly Execute SQL Queriesm

 IEnumerable<tbl_LeaderMaster> leader = obj.ExecuteQuery<tbl_LeaderMaster>("select * from tbl_LeaderMaster where leaderid in (select top(6) leaderid from tbl_CommRating order by outof)");

        DataList1.DataSource = leader;
        DataList1.DataBind();

No comments:

Post a Comment