Practical : 22
Subject : .Net
Aim : Create an application in C# to insert, delete, Edit the data using Grid View control.
Source Code :
//file.aspx
<%@ Page Language="C#"
AutoEventWireup="true" CodeBehind="pra21.aspx.cs"
Inherits="dotnet008asp.pra21" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>pratik008</title>
</head>
<body>
<form
id="form1" runat="server">
<div>
Name
<asp:TextBox ID="txtname"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
runat="server" ControlToValidate="txtname"
Display="Dynamic" EnableViewState="False" ErrorMessage="Required"
ForeColor="Red"></asp:RequiredFieldValidator>
</div>
<p>
Mobile
<asp:TextBox ID="txtmobile"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
runat="server" ControlToValidate="txtmobile"
Display="Dynamic" EnableViewState="False"
ErrorMessage="Required"
ForeColor="Red"></asp:RequiredFieldValidator>
</p>
<p>
Email
<asp:TextBox ID="txtemail" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3"
runat="server" ControlToValidate="txtemail"
Display="Dynamic" EnableViewState="False" ErrorMessage="Required"
ForeColor="Red"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator
ID="RegularExpressionValidator1" runat="server"
ControlToValidate="txtemail" Display="Dynamic"
ErrorMessage="RegularExpressionValidator" ForeColor="Red"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
</p>
<p>
Age <asp:TextBox
ID="txtage" runat="server"></asp:TextBox>
<asp:RangeValidator ID="RangeValidator1"
runat="server" ControlToValidate="txtage" Display="Dynamic"
ErrorMessage="RangeValidator(20-30)" ForeColor="Red"
MaximumValue="30"
MinimumValue="20"></asp:RangeValidator>
</p>
<p>
Password
<asp:TextBox ID="txtpwd"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4"
runat="server" ControlToValidate="txtpwd"
Display="Dynamic" EnableViewState="False" ErrorMessage="Required"
ForeColor="Red"></asp:RequiredFieldValidator>
</p>
<p>
Confirm
Password
<asp:TextBox ID="txtconfirmpwd"
runat="server"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator1"
runat="server" ControlToCompare="txtpwd"
ControlToValidate="txtconfirmpwd" Display="Dynamic"
ErrorMessage="CompareValidator (password)"
ForeColor="Red"></asp:CompareValidator>
</p>
<p>
<asp:Button ID="Button1"
runat="server" Text="submit" />
</p>
</form>
</body>
</html>
//file.aspx.cs
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;
namespace dotnet008asp
{
public partial
class pra22 : System.Web.UI.Page
{
protected void
Page_Load(object sender, EventArgs e)
{
if
(!IsPostBack)
{
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
}
protected void
GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
protected void
GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
protected void
GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label id =
GridView1.Rows[e.RowIndex].FindControl("Label6") as Label;
TextBox
name = GridView1.Rows[e.RowIndex].FindControl("TextBox2") as TextBox;
TextBox
enrl = GridView1.Rows[e.RowIndex].FindControl("TextBox3") as TextBox;
TextBox
branch = GridView1.Rows[e.RowIndex].FindControl("TextBox4") as
TextBox;
TextBox
collage = GridView1.Rows[e.RowIndex].FindControl("TextBox5") as
TextBox;
String
mycon = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pratik\Documents\crud.mdf;Integrated
Security=True;Connect Timeout=30";
String
updatedata = "Update stu_info set id='"+id.Text+"', name='"
+ name.Text + "', enrl='" + enrl.Text + "', branch='" +
branch.Text + "', collage='" + collage.Text + "' where id="
+ id.Text;
SqlConnection con = new SqlConnection(mycon);
con.Open();
SqlCommand
cmd = new SqlCommand();
cmd.CommandText = updatedata;
cmd.Connection = con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
SqlDataSource1.DataBind();
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
protected void
LinkButton5_Click(object sender, EventArgs e)
{
TextBox id
= GridView1.FooterRow.FindControl("TextBox6") as TextBox;
TextBox
name = GridView1.FooterRow.FindControl("TextBox7") as TextBox;
TextBox
enrl = GridView1.FooterRow.FindControl("TextBox8") as TextBox;
TextBox
branch = GridView1.FooterRow.FindControl("TextBox9") as TextBox;
TextBox
collage = GridView1.FooterRow.FindControl("TextBox10") as TextBox;
String
query = "insert into stu_info(id,name,enrl,branch,collage) values(" +
id.Text + ",'" + name.Text + "','" + enrl.Text +
"','" + branch.Text + "','" + collage.Text +
"')";
String
mycon = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pratik\Documents\crud.mdf;Integrated
Security=True;Connect Timeout=30";
SqlConnection con = new SqlConnection(mycon);
con.Open();
SqlCommand
cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = con;
cmd.ExecuteNonQuery();
SqlDataSource1.DataBind();
GridView1.DataSource
= SqlDataSource1;
GridView1.DataBind();
}
protected void
GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label id =
GridView1.Rows[e.RowIndex].FindControl("Label1") as Label;
String
mycon = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pratik\Documents\crud.mdf;Integrated
Security=True;Connect Timeout=30";
String
updatedata = "delete from stu_info where id=" + id.Text;
SqlConnection con = new SqlConnection(mycon);
con.Open();
SqlCommand
cmd = new SqlCommand();
cmd.CommandText = updatedata;
cmd.Connection
= con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
SqlDataSource1.DataBind();
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
}
}
//web.config
<configuration>
<connectionStrings>
<add
name="ConnectionString" connectionString="Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pratik\Documents\crud.mdf;Integrated
Security=True;Connect Timeout=30"/>
</connectionStrings>
</configuration>
//stu_info.sql
CREATE TABLE [dbo].[stu_info] (
[id] INT NOT NULL,
[name] VARCHAR (MAX) NULL,
[enrl] VARCHAR (MAX) NULL,
[branch] VARCHAR (50)
NULL,
[collage] VARCHAR
(MAX) NULL,
PRIMARY KEY
CLUSTERED ([id] ASC)
);
Output :
0 comments:
Post a Comment