insert through linq in database

   insert through linq in database and showing in gridview in asp.net

rollno.
name

rollno	name
243	mukjesh
345	raju

 first of  all  make  a class name bl ,
and do following code,



using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Linq;
using System.Data.Linq.Mapping;


namespace linqentity
{
    [Table(Name = ("emp"))]
    public class bl
    {
        [Column(Name="rollno",IsPrimaryKey=true)]
        public int rollno { get; set; }
        [Column(Name="Name1")]
        public string name { get; set; }
    }
}


now make   another class name dal,
then do following code,

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.Linq;        //here 

using System.Data.Linq.Mapping;  // these two namespace is necessaru foe linq table mapping with databse

namespace linqentity

{

    public class dal:DataContext

    {

        public dal(string myc)

            : base(myc)

        {

        }

        public Table<bl> st;//association

    }

}

 now open .aspx page and take two textbox , and one  button and a gridview 

 and do following code in button click, 

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

namespace linqentity

{

    public partial class _Default : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            bl b = new bl();

            b.rollno = Convert.ToInt32(TextBox1.Text);

            b.name = TextBox2.Text;

            dal d=new dal (@"database=msdb;data source=FAMILY-A990589E\SQLEXPRESS; integrated security=true;");

            d.st.InsertOnSubmit(b);

            d.SubmitChanges();//commit

            GridView1.DataSource=d.st;

            GridView1.DataBind();

        }

    }

}