Simply Open your web project go to solution explorer right click on your project add new Item and select Linq to Sql Classes and click add.
Notice that DataClasses1.dbml class has been added to your project, Click on this class.
Now, Open Server Explorer and expend your database and drag a table on DataClasses1.dbml.
Sql Table:
create table m_EduDetails
(
course_id int identity(1,1) primary key,
Degree nvarchar(50) not null,
Descrption nvarchar(255),
modified_date date
)
Now follow up this design and c# code.
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btnselect" runat="server" onclick="btnselect_Click"
Text="Select" />
<asp:Button ID="btnInsert" runat="server" onclick="btnInsert_Click"
Text="Insert" />
<asp:Button ID="btnUpdate" runat="server" onclick="btnUpdate_Click"
Text="Update" />
<asp:Button ID="btnDelete" runat="server" Text="Delete" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
protected void btnselect_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var details = from p in db.m_EduDetails
select p;
GridView1.DataSource=details;
GridView1.DataBind();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
m_EduDetails obj = new m_EduDetails();
obj.course_id = 1;
obj.Degree="btech";
obj.Description= "4 year degree";
obj.modifiedDate = DateTime.Now;
db.m_EduDetailss.InsertOnSubmit(obj);
db.SubmitChanges();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
DataClasses1DataContext OdContext = new DataClasses1DataContext();
m_EduDetails objD = OdContext.m_EduDetailss.Single(m_EduDetails=> m_EduDetails.course_id == 1);
objD.Description= "Update description";
OdContext.SubmitChanges();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
DataClasses1DataContext OdContext = new DataClasses1DataContext();
m_EduDetails objD = OdContext.m_EduDetailss.Single(m_EduDetails=> m_EduDetails.course_id == 1);
OdContext .m_EduDetailss.DeleteOnSubmit(objD);
OdContext.SubmitChanges();
}
Notice that DataClasses1.dbml class has been added to your project, Click on this class.
Now, Open Server Explorer and expend your database and drag a table on DataClasses1.dbml.
Sql Table:
create table m_EduDetails
(
course_id int identity(1,1) primary key,
Degree nvarchar(50) not null,
Descrption nvarchar(255),
modified_date date
)
Now follow up this design and c# code.
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btnselect" runat="server" onclick="btnselect_Click"
Text="Select" />
<asp:Button ID="btnInsert" runat="server" onclick="btnInsert_Click"
Text="Insert" />
<asp:Button ID="btnUpdate" runat="server" onclick="btnUpdate_Click"
Text="Update" />
<asp:Button ID="btnDelete" runat="server" Text="Delete" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
protected void btnselect_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var details = from p in db.m_EduDetails
select p;
GridView1.DataSource=details;
GridView1.DataBind();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
m_EduDetails obj = new m_EduDetails();
obj.course_id = 1;
obj.Degree="btech";
obj.Description= "4 year degree";
obj.modifiedDate = DateTime.Now;
db.m_EduDetailss.InsertOnSubmit(obj);
db.SubmitChanges();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
DataClasses1DataContext OdContext = new DataClasses1DataContext();
m_EduDetails objD = OdContext.m_EduDetailss.Single(m_EduDetails=> m_EduDetails.course_id == 1);
objD.Description= "Update description";
OdContext.SubmitChanges();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
DataClasses1DataContext OdContext = new DataClasses1DataContext();
m_EduDetails objD = OdContext.m_EduDetailss.Single(m_EduDetails=> m_EduDetails.course_id == 1);
OdContext .m_EduDetailss.DeleteOnSubmit(objD);
OdContext.SubmitChanges();
}
No comments:
Post a Comment