<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
::LINQ PROGRAM::
Asp.Cs page (Linq Insert,Delete,Update)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
getdetails();
}
//Select Query
private void getdetails()
{
DataClassesDataContext cons = new DataClassesDataContext();
var cust = from custom in cons.customer_Headers
select new
{
custom.CustomerId,
custom.CustomerCode
};
gvlist.DataSource = cust;
gvlist.DataBind();
}
//Insert Query
protected void btnclick_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
customer_Header sam = new customer_Header
{
CustomerCode = Convert.ToInt32(txtcustcode.Text),
CustomerId = txtcustid.Text
};
cons.customer_Headers.InsertOnSubmit(sam);
cons.SubmitChanges();
getdetails();
}
//Delete Query
protected void BtnDelete_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
Int32 str = Convert.ToInt32(txtcustcode.Text);
customer_Header custs = (from cuss in cons.customer_Headers
where cuss.CustomerCode == (str)
select cuss).Single();
cons.customer_Headers.DeleteOnSubmit(custs);
cons.SubmitChanges();
getdetails();
}
//Update Query
protected void btnUpdate_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
Int32 strs = Convert.ToInt32(txtcustcode.Text);
customer_Header custUp = (from cus in cons.customer_Headers where cus.CustomerCode == (strs) select cus).SingleOrDefault();
custUp.CustomerId = txtcustid.Text;
cons.SubmitChanges();
getdetails();
}
}
No comments:
Post a Comment