Hello there, here i m explaining how to use Databound fields
using gridview .
Now first of all we will create a database. Here the following script, copy it and run
it.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbEmp]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbEmp](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL,
[age] [int] NULL,
[address] [varchar](50) NULL
) ON [PRIMARY]
END
Place the
GridView control on a form and set the following property.
AutoGenerateColumns="False"
And set
the Gridview Events name is
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating"
<%@ Page Language="C#"
AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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 runat="server">
<title>Untitled
Page</title>
<style type="text/css">
.style1
{
width:
100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<table class="style1">
<tr>
<td>
Name</td>
<td>
<asp:TextBox ID="txt_name" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
Age</td>
<td>
<asp:TextBox ID="txt_age" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
Address</td>
<td>
<asp:TextBox ID="txt_address" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="lbl_msg" runat="server" ForeColor="Red"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowupdating="GridView1_RowUpdating" CellPadding="4"
ForeColor="#333333"
GridLines="None">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="id" HeaderText="Id" ReadOnly="True" />
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Age" HeaderText="Age" />
<asp:BoundField DataField="address" HeaderText="address" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
</tr>
</table>
</form>
</body>
</html>
In Coding
using System;
using
System.Configuration;
using
System.Data;
using
System.Linq;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Xml.Linq;
using
System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection
con = new SqlConnection();
SqlDataAdapter
adp;
SqlCommand
cmd;
DataTable
dt;
protected void Page_Load(object
sender, EventArgs e)
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;
con.Open();
if
(con.State == ConnectionState.Closed)
{ con.Open(); }
con.Close();
if
(IsPostBack == false)
{ grdview(); }
}
private void grdview()
{
if
(con.State == ConnectionState.Closed)
{ con.Open(); }
adp = new
SqlDataAdapter("select
* from tbemp order by id desc", con);
dt = new
DataTable();
adp.Fill(dt);
adp.Dispose();
if(dt.Rows.Count
== 0)
{
lbl_msg.Text = "No Record";
}
else
{
lbl_msg.Text = String.Empty;
GridView1.DataSource = dt;
GridView1.DataBind();
}
dt.Dispose();
con.Close();
}
protected void Button1_Click(object
sender, EventArgs e)
{
if
(con.State == ConnectionState.Closed)
{ con.Open(); }
cmd = new
SqlCommand("insert
into tbEmp values(@name,@age,@address)", con);
cmd.Parameters.AddWithValue("@name", txt_name.Text);
cmd.Parameters.AddWithValue("@age", txt_age.Text);
cmd.Parameters.AddWithValue("@address", txt_address.Text);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
grdview();
txt_name.Text = String.Empty;
txt_age.Text = String.Empty;
txt_address.Text = String.Empty;
}
// Deleting the Record
protected void GridView1_RowDeleting(object
sender, GridViewDeleteEventArgs e)
{
if
(con.State == ConnectionState.Closed)
{ con.Open(); }
Int32
idd = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);
cmd = new
SqlCommand("delete
from tbemp where id=@id", con);
cmd.Parameters.AddWithValue("@id", idd);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
grdview();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs
e)
{
GridView1.EditIndex = -1;
grdview();
}
protected void GridView1_RowEditing(object
sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
grdview();
}
protected void GridView1_RowUpdating(object
sender, GridViewUpdateEventArgs e)
{
if (con.State
== ConnectionState.Closed)
{ con.Open(); }
Int32
idd = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);
cmd = new
SqlCommand("update
tbemp set name=@name,age=@age,address=@address where id=@id", con);
cmd.Parameters.AddWithValue("@name", ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text);
cmd.Parameters.AddWithValue("@age", ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text);
cmd.Parameters.AddWithValue("@address", ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text);
cmd.Parameters.AddWithValue("@id", idd);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
GridView1.EditIndex = -1;
grdview();
}
}
EDIT RECORDS
EDITED RECORDS
No comments:
Post a Comment