crud Operation in grid View Use Disconnected Architecture
Write Program to perform insert , update, delete operation on grid view use disconnected Arcitecture.
Aspx File
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="demogv.aspx.cs" Inherits="demogv" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="Id" ShowFooter="true" OnRowEditing="GridView1_RowEditing" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowCommand="GridView1_RowCommand" OnRowDeleting="GridView1_RowDeleting" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:TemplateField HeaderText="Id">
<ItemTemplate><%#Eval("Id") %></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate><%#Eval("name") %></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtname" runat="server" Text='<%#Eval("name") %>'></asp:TextBox></EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtnameadd" runat="server" ></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department">
<ItemTemplate><%#Eval("dept") %></ItemTemplate>
<EditItemTemplate>
<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></EditItemTemplate>
<FooterTemplate>
<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></EditItemTemplate>
</FooterTemplate>
</asp:TemplateField >
<asp:TemplateField HeaderText="Semester">
<ItemTemplate><%#Eval("sem") %></ItemTemplate>
<EditItemTemplate>
<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></EditItemTemplate>
<FooterTemplate>
<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>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gender">
<ItemTemplate><%#Eval("gender") %></ItemTemplate>
<EditItemTemplate>
<asp:RadioButtonList ID="rbgender" runat="server" SelectedValue='<%#Eval("gender") %>'>
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
<FooterTemplate>
<asp:RadioButtonList ID="rbgenderadd" runat="server" >
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Crud Operation">
<ItemTemplate>
<asp:LinkButton ID="lbedit" runat="server" CommandName="Edit">Edit</asp:LinkButton>
<asp:LinkButton ID="lbdelete" runat="server" CommandName="Delete">Delete</asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="lbupdate" runat="server" CommandName="Update">Update</asp:LinkButton>
<asp:LinkButton ID="lbcancel" runat="server" CommandName="Cancel">Cancel</asp:LinkButton>
</EditItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="lbInsert" runat="server" CommandName="Insert">Insert</asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</asp:Content>
Aspx.cs file
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 demogv : 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);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
getdata();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
getdata();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Value);
TextBox txtname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
DropDownList ddlsem = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlsem");
DropDownList ddldept = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddldept");
RadioButtonList rbgen = (RadioButtonList)GridView1.Rows[e.RowIndex].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);
GridView1.EditIndex = -1;
getdata();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
TextBox txtname = (TextBox)GridView1.FooterRow.FindControl("txtnameadd");
DropDownList ddlsem = (DropDownList)GridView1.FooterRow.FindControl("ddlsemadd");
DropDownList ddldept = (DropDownList)GridView1.FooterRow.FindControl("ddldeptadd");
RadioButtonList rbgen = (RadioButtonList)GridView1.FooterRow.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"] = txtname.Text;
dr["dept"] = ddldept.SelectedItem.ToString();
dr["sem"] = ddlsem.SelectedItem.ToString();
dr["gender"] = rbgen.SelectedItem.ToString();
dt.Rows.Add(dr);
adpt.Update(dt);
getdata();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].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();
}
}
Comments
Post a Comment