crud operation on ListView Controls

Write a Program to perform insert, update, delete on listview controls use disconnected Architecture.

Required Master Page

ASPx Files

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="listview.aspx.cs" Inherits="listview" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:ListView ID="ListView1" DataKeyNames="Id" InsertItemPosition="FirstItem" runat="server" OnItemCanceling="ListView1_ItemCanceling" OnItemCommand="ListView1_ItemCommand" OnItemDeleting="ListView1_ItemDeleting" OnItemEditing="ListView1_ItemEditing" OnItemUpdating="ListView1_ItemUpdating" OnPagePropertiesChanging="ListView1_PagePropertiesChanging" OnItemInserting="ListView1_ItemInserting">
        <LayoutTemplate>
           <table>
               <tr>
                   <th>Id</th>
                   <th>Name</th>
                   <th>Department</th>
                   <th>Semster</th>
                   <th>gender</th>
                   <th>Operation</th>
               </tr>
               <tr runat="server" id="itemPlaceHolder">
                  
               </tr>
               <tr runat="server">
                   <td>
                       <asp:DataPager ID="DataPager1" runat="server" PageSize="2">
                           <Fields>
                               <asp:NumericPagerField ButtonType="Link"/>
                           </Fields>
                       </asp:DataPager>
                   </td>
               </tr>
          </table>
        </LayoutTemplate>
        <ItemTemplate>
               <tr>
               <td><%#Eval("Id") %></td>
               <td><%#Eval("name") %></td>
               <td><%#Eval("dept") %></td>
               <td><%#Eval("sem") %></td>
               <td><%#Eval("gender") %></td>
               <td>
                   <asp:LinkButton ID="lbedit" runat="server" CommandName="Edit">Edit</asp:LinkButton>
                   <asp:LinkButton ID="lbdelete" runat="server" CommandName="Delete">Delete</asp:LinkButton>
               </td>
           </tr>
        </ItemTemplate>
        <EditItemTemplate>
            <tr>
                <td><%#Eval("Id") %></td>
               <td><asp:TextBox ID="txtname" runat="server" Text='<%#Eval("name") %>'></asp:TextBox></td>
               <td><asp:DropDownList ID="ddldept" SelectedValue='<%#Eval("dept") %>' runat="server">
                        <asp:ListItem>CE</asp:ListItem>
                        <asp:ListItem>IT</asp:ListItem>
                        <asp:ListItem>EC</asp:ListItem>
                        <asp:ListItem>ME</asp:ListItem>
                        <asp:ListItem>EE</asp:ListItem>
                        <asp:ListItem>CV</asp:ListItem>
                    </asp:DropDownList></td>
               <td><asp:DropDownList ID="ddlsem" SelectedValue='<%#Eval("sem") %>' runat="server">
                        <asp:ListItem>1</asp:ListItem>
                        <asp:ListItem>2</asp:ListItem>
                        <asp:ListItem>3</asp:ListItem>
                        <asp:ListItem>4</asp:ListItem>
                        <asp:ListItem>5</asp:ListItem>
                        <asp:ListItem>6</asp:ListItem>
                        <asp:ListItem>7</asp:ListItem>
                    </asp:DropDownList></td>
               <td>
                   <asp:RadioButtonList ID="rbgender"  runat="server" SelectedValue='<%#Eval("gender") %>'>
                        <asp:ListItem>Male</asp:ListItem>
                        <asp:ListItem>Female</asp:ListItem>
                    </asp:RadioButtonList></td>
            
               <td>
                   <asp:LinkButton ID="lbUpdate" runat="server" CommandName="Update">Update</asp:LinkButton>
                   <asp:LinkButton ID="lbcancel" runat="server" CommandName="Cancel">Cancel</asp:LinkButton>
               </td>
           </tr>
        </EditItemTemplate>
        <InsertItemTemplate>
             <tr>
                <td></td>
               <td><asp:TextBox ID="txtnameadd" runat="server" ></asp:TextBox></td>
               <td><asp:DropDownList ID="ddldeptadd"  runat="server">
                        <asp:ListItem>CE</asp:ListItem>
                        <asp:ListItem>IT</asp:ListItem>
                        <asp:ListItem>EC</asp:ListItem>
                        <asp:ListItem>ME</asp:ListItem>
                        <asp:ListItem>EE</asp:ListItem>
                        <asp:ListItem>CV</asp:ListItem>
                    </asp:DropDownList></td>
               <td><asp:DropDownList ID="ddlsemadd"  runat="server">
                        <asp:ListItem>1</asp:ListItem>
                        <asp:ListItem>2</asp:ListItem>
                        <asp:ListItem>3</asp:ListItem>
                        <asp:ListItem>4</asp:ListItem>
                        <asp:ListItem>5</asp:ListItem>
                        <asp:ListItem>6</asp:ListItem>
                        <asp:ListItem>7</asp:ListItem>
                    </asp:DropDownList></td>
               <td>
                   <asp:RadioButtonList ID="rbgenderadd"  runat="server" >
                        <asp:ListItem>Male</asp:ListItem>
                        <asp:ListItem>Female</asp:ListItem>
                    </asp:RadioButtonList></td>
            
               <td>
                   <asp:LinkButton ID="lbinsert" runat="server" CommandName="Insert">Insert</asp:LinkButton>
                 
               </td>
        </InsertItemTemplate>
    </asp:ListView>
</asp:Content>

 

ASPx.cs Files

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class listview : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            getdata();
        }
    }
    public void getdata()
    {
        SqlDataAdapter adtp = new SqlDataAdapter("select * from student", con);
        DataSet ds = new DataSet();
        adtp.Fill(ds);
        ListView1.DataSource = ds.Tables[0];
        ListView1.DataBind();

    }
    protected void ListView1_ItemEditing(object sender, ListViewEditEventArgs e)
    {
        ListView1.EditIndex = e.NewEditIndex;
        getdata();
    }

    protected void ListView1_ItemCanceling(object sender, ListViewCancelEventArgs e)
    {
        ListView1.EditIndex = -1;
        getdata();
    }

    protected void ListView1_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {
        int id = Convert.ToInt16(ListView1.DataKeys[e.ItemIndex].Value);
        SqlDataAdapter adpt = new SqlDataAdapter("select * from student where Id='" + id + "'", con);
        SqlCommandBuilder scb = new SqlCommandBuilder(adpt);
        DataSet ds = new DataSet();
        adpt.Fill(ds);
        ds.Tables[0].Rows[0].Delete();
        adpt.Update(ds);
        getdata();
    }

    protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e)
    {
       
    }

    protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
    {
        int id = Convert.ToInt16(ListView1.DataKeys[e.ItemIndex].Value);
        TextBox txtname = (TextBox)ListView1.Items[e.ItemIndex].FindControl("txtname");
       DropDownList ddldept = (DropDownList)ListView1.Items[e.ItemIndex].FindControl("ddldept");
        DropDownList ddlsem = (DropDownList)ListView1.Items[e.ItemIndex].FindControl("ddlsem");
        RadioButtonList rbgen = (RadioButtonList)ListView1.Items[e.ItemIndex].FindControl("rbgender");
        SqlDataAdapter adpt = new SqlDataAdapter("select * from student where Id='" + id + "'", con);
        DataSet ds = new DataSet();
        adpt.Fill(ds);
        SqlCommandBuilder scb = new SqlCommandBuilder(adpt);
        ds.Tables[0].Rows[0]["name"] = txtname.Text;
        ds.Tables[0].Rows[0]["dept"] = ddldept.SelectedItem.ToString();
        ds.Tables[0].Rows[0]["sem"] = ddlsem.SelectedItem.ToString();
        ds.Tables[0].Rows[0]["gender"] = rbgen.SelectedItem.ToString();
        adpt.Update(ds);
        ListView1.EditIndex = -1;
        getdata();
    }

    protected void ListView1_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
    {
        (ListView1.FindControl("DataPager1") as DataPager).SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
        getdata();
         
    }

    protected void ListView1_ItemInserting(object sender, ListViewInsertEventArgs e)
    {
        TextBox txtnames = (TextBox)e.Item.FindControl("txtnameadd");
        DropDownList ddldepts = (DropDownList)e.Item.FindControl("ddldeptadd");
        DropDownList ddlsems = (DropDownList)e.Item.FindControl("ddlsemadd");
        RadioButtonList rbgens = (RadioButtonList)e.Item.FindControl("rbgenderadd");
        SqlDataAdapter adpt = new SqlDataAdapter("select * from student", con);
        DataTable dt = new DataTable();
        SqlCommandBuilder scb = new SqlCommandBuilder(adpt);
        adpt.Fill(dt);
        DataRow dr = dt.NewRow();
        dr["name"] = txtnames.Text;
        dr["dept"] = ddldepts.SelectedItem.ToString();
        dr["sem"] = ddlsems.SelectedItem.ToString();
        dr["gender"] = rbgens.SelectedItem.ToString();
        dt.Rows.Add(dr);
        adpt.Update(dt);
        getdata();
    }
}