Saturday, 8 March 2014

Linq Program
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> ::LINQ PROGRAM::
Customer Code
Customer Name

Customer Name <%#Eval("CustomerId")%> Customer Code <%#Eval("CustomerCode")%>
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