CRUD Application With Grid View And SQL Data Source In ASP.NET Web Forms

 using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;


namespace CRUD_WITH_GRIDVIEW

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {


        }


        protected void LinkButton1_Click(object sender, EventArgs e)

        {

            SqlDataSource1.InsertParameters["name"].DefaultValue =

                ((TextBox)GridView1.FooterRow.FindControl("FooterName")).Text;


            SqlDataSource1.InsertParameters["gender"].DefaultValue =

                ((DropDownList)GridView1.FooterRow.FindControl("FooterDdlGender")).SelectedValue;


            SqlDataSource1.InsertParameters["class"].DefaultValue =

                ((TextBox)GridView1.FooterRow.FindControl("FooterClass")).Text;


            int a = SqlDataSource1.Insert();

            if (a > 0)

            {

                Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Insertion Successfull !!')</script>");

            }

            else

            {

                Page.ClientScript.RegisterStartupScript(this.GetType(),"Scripts","<script>alert('Insertion Failed !!')</script>");

            }

        }

    }

}

Above File is CRUD_WITH_GRIDVIEW\WebForm1.aspx.cs





<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="CRUD_WITH_GRIDVIEW.WebForm1" %>


<!DOCTYPE html>


<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataKeyNames="Id" DataSourceID="SqlDataSource1" ForeColor="Black" ShowFooter="True">

            <Columns>

                <asp:TemplateField HeaderText="Id" InsertVisible="False" SortExpression="Id">

                    <EditItemTemplate>

                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("Id") %>'></asp:Label>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("Id") %>'></asp:Label>

                    </ItemTemplate>

                    <FooterTemplate>

                        <asp:LinkButton OnClick="LinkButton1_Click" ValidationGroup="Insert" ID="LinkButton1" runat="server">Insert</asp:LinkButton>

                    </FooterTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="name" SortExpression="name">

                    <EditItemTemplate>

                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>'></asp:TextBox>

                        <asp:RequiredFieldValidator ControlToValidate="TextBox1" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator1" runat="server" ErrorMessage="Name is a required field"></asp:RequiredFieldValidator>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("name") %>'></asp:Label>

                    </ItemTemplate>

                    <FooterTemplate>

                        <asp:TextBox ID="FooterName" runat="server"></asp:TextBox>

                        <asp:RequiredFieldValidator ValidationGroup="Insert" ControlToValidate="FooterName" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator2" runat="server" ErrorMessage="Name is a required field"></asp:RequiredFieldValidator>

                    </FooterTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="gender" SortExpression="gender">

                    <EditItemTemplate>

                        <asp:DropDownList ID="DropDownList" runat="server" Text='<%# Bind("gender") %>'>

                            <asp:ListItem>Select Gender</asp:ListItem>

                            <asp:ListItem>Male</asp:ListItem>

                            <asp:ListItem>Female</asp:ListItem>

                        </asp:DropDownList>

                        <asp:RequiredFieldValidator InitialValue="Select Gender" ControlToValidate="DropDownList" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator3" runat="server" ErrorMessage="Gender is a required field"></asp:RequiredFieldValidator>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("gender") %>'></asp:Label>

                    </ItemTemplate>

                    <FooterTemplate>

                        <asp:DropDownList ID="FooterDdlGender" runat="server">

                            <asp:ListItem>Select Gender</asp:ListItem>

                            <asp:ListItem>Male</asp:ListItem>

                            <asp:ListItem>Female</asp:ListItem>

                        </asp:DropDownList>

                        <asp:RequiredFieldValidator ValidationGroup="Insert" InitialValue="Select Gender" ControlToValidate="FooterDdlGender" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator4" runat="server" ErrorMessage="Gender is a required field"></asp:RequiredFieldValidator>

                    </FooterTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="class" SortExpression="class">

                    <EditItemTemplate>

                        <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("class") %>'></asp:TextBox>

                    <asp:RequiredFieldValidator ControlToValidate="TextBox3" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator5" runat="server" ErrorMessage="Class is a required field"></asp:RequiredFieldValidator>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("class") %>'></asp:Label>

                    </ItemTemplate>

                    <FooterTemplate>

                        <asp:TextBox ID="FooterClass" runat="server"></asp:TextBox>

                    <asp:RequiredFieldValidator ValidationGroup="Insert" ControlToValidate="FooterClass" ForeColor="Red" Text="*" SetFocusOnError="true" ID="RequiredFieldValidator6" runat="server" ErrorMessage="Class is a required field"></asp:RequiredFieldValidator>

                    </FooterTemplate>

                </asp:TemplateField>

            </Columns>

            <FooterStyle BackColor="#CCCCCC" />

            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />

            <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />

            <RowStyle BackColor="White" />

            <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />

            <SortedAscendingCellStyle BackColor="#F1F1F1" />

            <SortedAscendingHeaderStyle BackColor="#808080" />

            <SortedDescendingCellStyle BackColor="#CAC9C9" />

            <SortedDescendingHeaderStyle BackColor="#383838" />

        </asp:GridView>

        <asp:ValidationSummary ValidationGroup="Insert" ID="ValidationSummary1" runat="server" BackColor="#CCCCCC" Font-Size="Larger" ForeColor="Red" />

        <asp:ValidationSummary ID="ValidationSummary2" runat="server" BackColor="#CCCCCC" Font-Size="Larger" ForeColor="Red"/>

        <div>

            <br />

            <br />

            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [Student] WHERE [Id] = @Id" InsertCommand="INSERT INTO [Student] ([name], [gender], [class]) VALUES (@name, @gender, @class)" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Student]" UpdateCommand="UPDATE [Student] SET [name] = @name, [gender] = @gender, [class] = @class WHERE [Id] = @Id">

                <DeleteParameters>

                    <asp:Parameter Name="Id" Type="Int32" />

                </DeleteParameters>

                <InsertParameters>

                    <asp:Parameter Name="name" Type="String" />

                    <asp:Parameter Name="gender" Type="String" />

                    <asp:Parameter Name="class" Type="Int32" />

                </InsertParameters>

                <UpdateParameters>

                    <asp:Parameter Name="name" Type="String" />

                    <asp:Parameter Name="gender" Type="String" />

                    <asp:Parameter Name="class" Type="Int32" />

                    <asp:Parameter Name="Id" Type="Int32" />

                </UpdateParameters>

            </asp:SqlDataSource>

        </div>

    </form>

</body>

</html>

Above File is CRUD_WITH_GRIDVIEW\WebForm1.aspx















Comments

Post a Comment

Popular posts from this blog

Range Validator Control In ASP.NET Web forms | Form Validation | ASP.NET Web forms

Image
 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace VALIDATION_CONTROLS {     public partial class VALIDATION_FORM : System.Web.UI.Page     {         protected void Page_Load(object sender, EventArgs e)         {         }         protected void Button1_Click(object sender, EventArgs e)         {             Page.ClientScript.RegisterStartupScript(this.GetType(),"Scripts","<script>alert('YOUR FORM HAS BEEN SUBMITTED !!')</script>");         }     } } Above File is VALIDATION_CONTROLS\VALIDATION_FORM.aspx.cs
Read more

Query String In ASP.NET Web Forms | State Management | ASP.NET | Web Forms

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="QueryStringDemo_Practice.WebForm1" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <style type="text/css">         .auto-style1{             width:400px;         }         .auto-style2 {             width: 129px;         }     </style> </head> <body>     <form id="form1" runat="server">         <div>             <table cellpadding="4" cellspacing="4" class="auto-style1">                 <tr>                     <td class="auto-style2"...
Read more

Validation Summary Control In ASP.NET Web forms | Form Validation | ASP.NET

Image
 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace VALIDATION_CONTROLS {     public partial class VALIDATION_FORM : System.Web.UI.Page     {         protected void Page_Load(object sender, EventArgs e)         {         }         protected void Button1_Click(object sender, EventArgs e)         {             Page.ClientScript.RegisterStartupScript(this.GetType(),"Scripts","<script>alert('YOUR FORM HAS BEEN SUBMITTED !!')</script>");         }     } } Above File is VALIDATION_CONTROLS\VALIDATION_FORM.aspx.cs
Read more