ARTICLE

Select and Delete Data With LINQ Using XSD

Posted by Vijay Prativadi in Articles | LINQ on November 11, 2012

Tags: C#, DataSet, Delete data using XSD , HTML, LINQ, Select data using XSD, XSD, XSD with LINQ

Today, in this article let's play around with one of the interesting and most useful concept of Select and Delete Data in LINQ.

Tweet
1558
0

Reader Level: Intermediate

Introduction

Question: What is select data with LINQ using XSD?

In simple terms "It enables selection of data using XSD with LINQ queries".

Step 1: Create a new webform project:

Step 2: Add a new XSD dataset item:

Step 3: Add a new employee table to the dataset:

Step 4: The complete code of webform1.aspx looks like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="LINQtoXSDSelectApp.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <style type="text/css">
        .grid
        {
            margin-top: 50px;
        }
    </style>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <center>
        <div>
            <table>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Label ID="Label1" runat="server" Text="Select Data with LINQ using XSD (DataSet)"
                            Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Button ID="Button1" runat="server" Text="Select Data" Font-Names="Verdana" Width="213px"
                            BackColor="Orange" Font-Bold="True" OnClick="Button1_Click" />
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:GridView ID="GridView1" runat="server" CssClass="grid" BackColor="LightGoldenrodYellow"
                            BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">
                            <AlternatingRowStyle BackColor="PaleGoldenrod" />
                            <FooterStyle BackColor="Tan" />
                            <HeaderStyle BackColor="Tan" Font-Bold="True" />
                            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                            <SortedAscendingCellStyle BackColor="#FAFAE7" />
                            <SortedAscendingHeaderStyle BackColor="#DAC09E" />
                            <SortedDescendingCellStyle BackColor="#E1DB9C" />
                            <SortedDescendingHeaderStyle BackColor="#C2A47B" />
                        </asp:GridView>
                    </td>
                </tr>
            </table>
        </div>
    </center>
    </form>
</body>
</html>

Step 5: The complete code of webform1.aspx.cs looks like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace LINQtoXSDSelectApp
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            EmployeeDS.EmployeeDataTable objEmployeeTable = objAdapter.GetData();
            var query = from r in objEmployeeTable select new
            {
                FirstName = r.FirstName, LastName = r.LastName, Age = r.Age };
            GridView1.DataSource = query;
            GridView1.DataBind();
        }
        #region Instance MembersEmployeeDSTableAdapters.EmployeeTableAdapter
        objAdapter = new EmployeeDSTableAdapters.EmployeeTableAdapter();
        #endregion
    }
}

Step 6: The output of the application looks like this:

Step 7: The select output operation of the application looks like this:

Question: What is delete data with LINQ using XSD?

In simple terms "It enables data to be deleted using XSD with LINQ queries".

Step 1: Create a new webform project

Step 2: Add a new XSD dataset item

Step 3: Add a new employee table to the dataset:

Output3 (1).png

Step 4: The complete code of webform1.aspx looks like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="LINQtoXSDDeleteApp.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <style type="text/css">
        .grid
        {
            margin-top: 50px;
        }
    </style>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <center>
        <div>
            <table>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Label ID="Label1" runat="server" Text="Delete Data with LINQ using XSD (DataSet)"
                            Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="Label2" runat="server" Text="Please Enter Employee Id" ForeColor="Brown"
                            Font-Bold="true" Font-Size="Medium" Font-Names="Verdana"></asp:Label>
                    </td>
                    <td>
                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Button ID="Button1" runat="server" Text="Delete Data" Font-Names="Verdana" Width="213px"
                            BackColor="Orange" Font-Bold="True" OnClick="Button1_Click" />
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:GridView ID="GridView1" runat="server" CssClass="grid" BackColor="LightGoldenrodYellow"
                            BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">
                            <AlternatingRowStyle BackColor="PaleGoldenrod" />
                            <FooterStyle BackColor="Tan" />
                            <HeaderStyle BackColor="Tan" Font-Bold="True" />
                            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                            <SortedAscendingCellStyle BackColor="#FAFAE7" />
                            <SortedAscendingHeaderStyle BackColor="#DAC09E" />
                            <SortedDescendingCellStyle BackColor="#E1DB9C" />
                            <SortedDescendingHeaderStyle BackColor="#C2A47B" />
                        </asp:GridView>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Label ID="Label3" runat="server" Font-Bold="true" Font-Size="Medium" Font-Names="Verdana"></asp:Label>
                    </td>
                </tr>
            </table>
        </div>
    </center>
    </form>
</body>
</html>

Step 5: The complete code of webform1.aspx.cs looks like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace LINQtoXSDDeleteApp
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(TextBox1.Text))
            {
                Label3.Text = "Please Enter Some Values";
                Label3.ForeColor = System.Drawing.Color.Red;
            }
            else
            {
                objAdapter.Delete(int.Parse(TextBox1.Text));
                EmployeeDS.EmployeeDataTable objEmployeeTable = objAdapter.GetData();
                var query = from r in objEmployeeTable select new
                {
                    FirstName = r.FirstName, LastName = r.LastName, Age = r.Age };
                    GridView1.DataSource = query;
                }
            GridView1.DataBind();
            Label3.Text = "Records Deleted Successfully";
            Label3.ForeColor = System.Drawing.Color.Green;T
                extBox1.Text = string.Empty;
        }
        }
        #region Instance MembersEmployeeDSTableAdapters.EmployeeTableAdapter
        objAdapter = new EmployeeDSTableAdapters.EmployeeTableAdapter();
        #endregion
    }
}

Step 6: The output of the application looks like this:

Output4 (1).png

Step 7: The data deleted output of the application looks like this:

I hope this article is useful for you.. I look forward for your comments and feedback..Thanks Vijay Prativadi

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

Insert and Update Data With LINQ Using XSD

Tags: C#, DataSet, HTML, Insert Data, LINQ, Typed DataSet , Update Data, XSD
Play With First ()/FirstOrDefault () or Single ()/SingleOrDefault () in LINQ

Tags: C#, First, FirstOrDefault, HTML, LINQ, Single, SingleOrDefault

post comment

COMMENT USING

PREMIUM SPONSORS

DynamicPDF Developer Components

DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and add new content to existing PDF documents from within your applications.

TRENDING UP

Create Outlook Add-in by MAPI Functionality by Using Visual Studio 2010 Outlook Project Debugging jQuery in ASP.NET How to Enable Sign in as Different User Option in SharePoint 2013 Top 10 HTML5 Interview Questions Find and Delete Duplicate Records From SQL Table Panel Default Button is Not Working For Rad Combobox Custom Paging With GridView in ASP.NET 4.5 Working With Database in HTML5 Extending WinJS ListView With Custom Item Events Encrypt and Decrypt in SQL Server: Part 2

View All

MOST LIKED ARTICLE

WCF Introduction and Contracts - Day 1 Create SSRS Report Using Report Wizard CREATE READ UPDATE and DELETE - CRUD Operation Using LINQ to SQL WCF - Data Contract - Day 4 Factory Design Pattern

Follow @twitterapi

Options	Votes	%
Lenovo	19	13.19
HP	6	4.17
Dell	17	11.81
Toshiba	54	37.50
Acer	43	29.86
Sony	5	3.47
Total	144	100%

In Focus

Select and Delete Data With LINQ Using XSD

Related Articles


Favorite Computer Manufacturer

Who is your favorite Computer manufacturer?

Lenovo HP Dell Toshiba Acer Sony