Saturday, 9 March 2013

What is LINQ

What is Linq? It is Language Integration Query. If someone does not know about the syntax of SQL Server (working in SQL Environment). After understanding the syntax of LINQ they can easily work with Microsoft SQL Server . Like: - Insert command, Select Command, Update Command and Delete Command. In Linq we use var keyword to declare any object . For example:- Var obj=123; Var objstring=”rahul Gupta” etc…… If we declare an object with var keyword then the object can store any type of Value. ...

Linq Without DBML File

ASPX.CS Code .CS Code (Class file) using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data.Linq.Mapping; [Table(Name = "stu_info")] public class Person {     [Column(IsPrimaryKey = true, IsDbGenerated = true)]     public int roll { get; set; }     [Column]     public string Name { get; set; }    ...

Friday, 8 March 2013

How to insert record into identity column in Sql Server

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} How...

Thursday, 7 March 2013

How to Insert Record with Footer Row Controls

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; ...