<iframe src="http://wikimapia.org/#lat=26.0439825&lon=79.6216965&z=13&l=0&ifr=1&m=b" width="366" height="150" frameborder="0"></iframe>
Monday, March 7, 2011
Monday, February 21, 2011
Insert/Update/Delete in gridview asp.net
Insert/Update/Delete in GridView using asp.net C#
Insert/Update/Delete in GridView using asp.net C#
Step1:-
Create a employee table:
CREATE TABLE EMPLOYEE
(
EMPID INT IDENTITY(100,1),
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
ADDRESS VARCHAR(100),
MOBILE VARCHAR(20)
)
NOW INSERT SOME VALUES IN EMPLOYEE TABLE:
INSERT INTO EMPLOYEE(FIRSTNAME,LASTNAME, ADDRESS,MOBILE)VALUES('SHIVAM' ,'GUPTA','NEW DELHI','8826743157')
STEP2:- CREATE CONNECTION STRING IN WEB.CONFIG FILE.
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data. SqlClient"/>
</connectionStrings>
STEP3:- TAKE A GRIDVIEW IN YOUR .ASPX PAGE.
<asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton=" true" AutoGenerateColumns="false"
AutoGenerateEditButton="True"
onpageindexchanging=" GridView1_PageIndexChanging"
onrowcancelingedit=" GridView1_RowCancelingEdit" DataKeyNames="EmpID"
onrowdeleting="GridView1_ RowDeleting" onrowediting="GridView1_ RowEditing"
onrowupdating="GridView1_ RowUpdating">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
STEP4: NOW COME IN YOUR CODE BEHIND .ASPX.CS
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration. ConfigurationManager. ConnectionStrings["mycon"]. ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", Con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
int Eid = Convert.ToInt32(GridView1. DataKeys[e.RowIndex].Value);
string FirstName = ((TextBox)row.Cells[2]. Controls[0]).Text.ToString(). Trim();
string LastName = ((TextBox)row.Cells[3]. Controls[0]).Text.ToString(). Trim();
string Address = ((TextBox)row.Cells[4]. Controls[0]).Text.ToString(). Trim();
string Mobile = ((TextBox)row.Cells[5]. Controls[0]).Text.ToString(). Trim();
string sql = "UPDATE EMPLOYEE SET FIRSTNAME='" + FirstName + "',LastName='" + LastName + "',Address='" +Address + "',Mobile='" + Mobile + "' WHERE EMPID=" + Eid + "";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
int temp = cmd.ExecuteNonQuery();
con.Close();
if (temp == 1)
{
lblMessage.Text = "Record updated successfully";
}
GridView1.EditIndex = -1;
FillGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Eid = Convert.ToInt32(GridView1. DataKeys[e.RowIndex].Value);
SqlCommand cmd = new SqlCommand("DELETE FROM EMPLOYEE WHERE EMPID=" + Eid + "", con);
con.Open();
int temp = cmd.ExecuteNonQuery();
if (temp == 1)
{
lblMessage.Text = "Record deleted successfully";
}
con.Close();
FillGrid();
}
protected void GridView1_PageIndexChanging( object sender, GridViewPageEventArgs e)
{
GridView1.EditIndex = e.NewPageIndex;
FillGrid();
}
protected void GridView1_RowCancelingEdit( object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
FillGrid();
}
}
Insert/Update/Delete in GridView using asp.net C#Step1:-
Create a employee table:
CREATE TABLE EMPLOYEE
(
EMPID INT IDENTITY(100,1),
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
ADDRESS VARCHAR(100),
MOBILE VARCHAR(20)
)
NOW INSERT SOME VALUES IN EMPLOYEE TABLE:
INSERT INTO EMPLOYEE(FIRSTNAME,LASTNAME,
STEP2:- CREATE CONNECTION STRING IN WEB.CONFIG FILE.
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.
</connectionStrings>
STEP3:- TAKE A GRIDVIEW IN YOUR .ASPX PAGE.
<asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton="
AutoGenerateEditButton="True"
onpageindexchanging="
onrowcancelingedit="
onrowdeleting="GridView1_
onrowupdating="GridView1_
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
STEP4: NOW COME IN YOUR CODE BEHIND .ASPX.CS
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", Con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
int Eid = Convert.ToInt32(GridView1.
string FirstName = ((TextBox)row.Cells[2].
string LastName = ((TextBox)row.Cells[3].
string Address = ((TextBox)row.Cells[4].
string Mobile = ((TextBox)row.Cells[5].
string sql = "UPDATE EMPLOYEE SET FIRSTNAME='" + FirstName + "',LastName='" + LastName + "',Address='" +Address + "',Mobile='" + Mobile + "' WHERE EMPID=" + Eid + "";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
int temp = cmd.ExecuteNonQuery();
con.Close();
if (temp == 1)
{
lblMessage.Text = "Record updated successfully";
}
GridView1.EditIndex = -1;
FillGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Eid = Convert.ToInt32(GridView1.
SqlCommand cmd = new SqlCommand("DELETE FROM EMPLOYEE WHERE EMPID=" + Eid + "", con);
con.Open();
int temp = cmd.ExecuteNonQuery();
if (temp == 1)
{
lblMessage.Text = "Record deleted successfully";
}
con.Close();
FillGrid();
}
protected void GridView1_PageIndexChanging(
{
GridView1.EditIndex = e.NewPageIndex;
FillGrid();
}
protected void GridView1_RowCancelingEdit(
{
GridView1.EditIndex = -1;
FillGrid();
}
}
Insert/Update/Delete in GridView using asp.net C#
Step1:-
Create a employee table:
CREATE TABLE EMPLOYEE
(
EMPID INT IDENTITY(100,1),
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
ADDRESS VARCHAR(100),
MOBILE VARCHAR(20)
)
NOW INSERT SOME VALUES IN EMPLOYEE TABLE:
INSERT INTO EMPLOYEE(FIRSTNAME,LASTNAME, ADDRESS,MOBILE)VALUES('SHIVAM' ,'GUPTA','NEW DELHI','8826743157')
STEP2:- CREATE CONNECTION STRING IN WEB.CONFIG FILE.
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data. SqlClient"/>
</connectionStrings>
STEP3:- TAKE A GRIDVIEW IN YOUR .ASPX PAGE.
<asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton=" true" AutoGenerateColumns="false"
AutoGenerateEditButton="True"
onpageindexchanging=" GridView1_PageIndexChanging"
onrowcancelingedit=" GridView1_RowCancelingEdit" DataKeyNames="EmpID"
onrowdeleting="GridView1_ RowDeleting" onrowediting="GridView1_ RowEditing"
onrowupdating="GridView1_ RowUpdating">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
STEP4: NOW COME IN YOUR CODE BEHIND .ASPX.CS
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration. ConfigurationManager. ConnectionStrings["mycon"]. ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", Con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
int Eid = Convert.ToInt32(GridView1. DataKeys[e.RowIndex].Value);
string FirstName = ((TextBox)row.Cells[2]. Controls[0]).Text.ToString(). Trim();
string LastName = ((TextBox)row.Cells[3]. Controls[0]).Text.ToString(). Trim();
string Address = ((TextBox)row.Cells[4]. Controls[0]).Text.ToString(). Trim();
string Mobile = ((TextBox)row.Cells[5]. Controls[0]).Text.ToString(). Trim();
string sql = "UPDATE EMPLOYEE SET FIRSTNAME='" + FirstName + "',LastName='" + LastName + "',Address='" +Address + "',Mobile='" + Mobile + "' WHERE EMPID=" + Eid + "";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
int temp = cmd.ExecuteNonQuery();
con.Close();
if (temp == 1)
{
lblMessage.Text = "Record updated successfully";
}
GridView1.EditIndex = -1;
FillGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Eid = Convert.ToInt32(GridView1. DataKeys[e.RowIndex].Value);
SqlCommand cmd = new SqlCommand("DELETE FROM EMPLOYEE WHERE EMPID=" + Eid + "", con);
con.Open();
int temp = cmd.ExecuteNonQuery();
if (temp == 1)
{
lblMessage.Text = "Record deleted successfully";
}
con.Close();
FillGrid();
}
protected void GridView1_PageIndexChanging( object sender, GridViewPageEventArgs e)
{
GridView1.EditIndex = e.NewPageIndex;
FillGrid();
}
protected void GridView1_RowCancelingEdit( object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
FillGrid();
}
}
Step1:-
Create a employee table:
CREATE TABLE EMPLOYEE
(
EMPID INT IDENTITY(100,1),
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
ADDRESS VARCHAR(100),
MOBILE VARCHAR(20)
)
NOW INSERT SOME VALUES IN EMPLOYEE TABLE:
INSERT INTO EMPLOYEE(FIRSTNAME,LASTNAME,
STEP2:- CREATE CONNECTION STRING IN WEB.CONFIG FILE.
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.
</connectionStrings>
STEP3:- TAKE A GRIDVIEW IN YOUR .ASPX PAGE.
<asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton="
AutoGenerateEditButton="True"
onpageindexchanging="
onrowcancelingedit="
onrowdeleting="GridView1_
onrowupdating="GridView1_
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
STEP4: NOW COME IN YOUR CODE BEHIND .ASPX.CS
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", Con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
int Eid = Convert.ToInt32(GridView1.
string FirstName = ((TextBox)row.Cells[2].
string LastName = ((TextBox)row.Cells[3].
string Address = ((TextBox)row.Cells[4].
string Mobile = ((TextBox)row.Cells[5].
string sql = "UPDATE EMPLOYEE SET FIRSTNAME='" + FirstName + "',LastName='" + LastName + "',Address='" +Address + "',Mobile='" + Mobile + "' WHERE EMPID=" + Eid + "";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
int temp = cmd.ExecuteNonQuery();
con.Close();
if (temp == 1)
{
lblMessage.Text = "Record updated successfully";
}
GridView1.EditIndex = -1;
FillGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Eid = Convert.ToInt32(GridView1.
SqlCommand cmd = new SqlCommand("DELETE FROM EMPLOYEE WHERE EMPID=" + Eid + "", con);
con.Open();
int temp = cmd.ExecuteNonQuery();
if (temp == 1)
{
lblMessage.Text = "Record deleted successfully";
}
con.Close();
FillGrid();
}
protected void GridView1_PageIndexChanging(
{
GridView1.EditIndex = e.NewPageIndex;
FillGrid();
}
protected void GridView1_RowCancelingEdit(
{
GridView1.EditIndex = -1;
FillGrid();
}
}
get primary key in gridview
*********RowCommand_event of Gridview*************
Step1: Add the gridview in your .aspx page.
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
DataKeyNames="EmpID"onrowcommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnSelect" runat="server" Text="Select" CommandName="Select" CommandArgument='<%# Eval("Mobile") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
<asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>
</div>
step 2:- your .aspx.cs page.
NOTE:- this is my connection string which is using in below coding you can use your own to modify it in your web.config file.
My connectiion string is.
"
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>
"
**********************your code behind part.*********************
public partial class SelectGridColumn : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
txtMobile.Text = Convert.ToString(e.CommandArgument);
lblMessage.Text = "this the mobile no of selected row!";
}
}
}
Step1: Add the gridview in your .aspx page.
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
DataKeyNames="EmpID"onrowcommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnSelect" runat="server" Text="Select" CommandName="Select" CommandArgument='<%# Eval("Mobile") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
<asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>
</div>
step 2:- your .aspx.cs page.
NOTE:- this is my connection string which is using in below coding you can use your own to modify it in your web.config file.
My connectiion string is.
"
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>
"
**********************your code behind part.*********************
public partial class SelectGridColumn : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
txtMobile.Text = Convert.ToString(e.CommandArgument);
lblMessage.Text = "this the mobile no of selected row!";
}
}
}
row command in griedview asp.net C#
*********RowCommand_event of Gridview*************
Step1: Add the gridview in your .aspx page.
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
DataKeyNames="EmpID"onrowcommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnSelect" runat="server" Text="Select" CommandName="Select" CommandArgument='<%# Eval("Mobile") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
<asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>
</div>
step 2:- your .aspx.cs page.
NOTE:- this is my connection string which is using in below coding you can use your own to modify it in your web.config file.
My connectiion string is.
"
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>
"
**********************your code behind part.*********************
public partial class SelectGridColumn : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
txtMobile.Text = Convert.ToString(e.CommandArgument);
lblMessage.Text = "this the mobile no of selected row!";
}
}
}
Step1: Add the gridview in your .aspx page.
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
DataKeyNames="EmpID"onrowcommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="EMPID" HeaderText="EmployeeID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnSelect" runat="server" Text="Select" CommandName="Select" CommandArgument='<%# Eval("Mobile") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server"></asp:Label>
<asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>
</div>
step 2:- your .aspx.cs page.
NOTE:- this is my connection string which is using in below coding you can use your own to modify it in your web.config file.
My connectiion string is.
"
<connectionStrings>
<add name="mycon" connectionString="data source=SHIVAMGUPTA; initial catalog=operation; integrated security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>
"
**********************your code behind part.*********************
public partial class SelectGridColumn : System.Web.UI.Page
{
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
string conection;
conection = System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString.ToString();
con = new SqlConnection(conection);
if (!IsPostBack)
{
FillGrid();
}
}
protected void FillGrid()
{
SqlCommand cmd = new SqlCommand("select * from employee", con);
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
txtMobile.Text = Convert.ToString(e.CommandArgument);
lblMessage.Text = "this the mobile no of selected row!";
}
}
}
how to insert value in identy
----------------INSERT VALUE IN IDENTITY COLUM
SET IDENTITY_INSERT EMPLOYEE ON
INSERT INTO EMPLOYEE(EID,ENAME,EADD)
VALUES(1,'SHIVAM','JHANSI/NEW DELHI')
SET IDENTITY_INSERT EMPLOYEE OFF
--------------------------------
SET IDENTITY_INSERT EMPLOYEE ON
INSERT INTO EMPLOYEE(EID,ENAME,EADD)
VALUES(1,'SHIVAM','JHANSI/NEW DELHI')
SET IDENTITY_INSERT EMPLOYEE OFF
--------------------------------
Fully Editable GridView in ASP.NET 2 using C#
This post demonstrate how to make a GridView editable all the time using C# asp.net.
step1-: Create a table with name " items" with following columns("iterm_no","name","price")
where "iterm_no" is identity column.as describe below
create table items
(
iterm_no int identity(1,1),
name varchar(20),
price numeric(10,2)
)
step2- Now create a web page with name(EditableGridView). as describe below.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EditableGridView.aspx.cs" Inherits="EditableGridView" %>
<!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>Editable GridView</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="INTERM_NO" >
<FooterStyle BackColor="White" ForeColor="#000066" />
<Columns>
<asp:BoundField DataField="INTERM_NO" HeaderText="ITEM_N0" InsertVisible="False" ReadOnly="True"
SortExpression="INTERM_NO" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'
OnTextChanged="TextBox_TextChanged" BorderStyle="None"></asp:TextBox>
<asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("INTERM_NO") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PRICE" SortExpression="PRICE">
<ItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("PRICE") %>'
OnTextChanged="TextBox_TextChanged" BorderStyle="None"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
<asp:Button ID="btnUpdate" runat="server" onclick="btnUpdate_Click"
Text="Update" />
<asp:Label ID="lblMessage" runat="server"></asp:Label>
</form>
</body>
</html>
step 3- Go to your code behind (EditableGridView.cs) as describe below.
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class EditableGridView : System.Web.UI.Page
{
SqlConnection con;
bool[] rowChanged;
protected void Page_Load(object sender, EventArgs e)
{
string conString = ConfigurationSettings.AppSettings["mycon"];
con = new SqlConnection(conString);
int totalRows = GridView1.Rows.Count;
rowChanged = new bool[totalRows];
if (!Page.IsPostBack)
{
BindGrid();
}
}
public void BindGrid()
{
SqlDataAdapter adap = new SqlDataAdapter("select * from items", con);
DataTable dt = new DataTable();
adap.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void TextBox_TextChanged(object sender, EventArgs e)
{
TextBox thisTextBox = (TextBox)sender;
GridViewRow thisGridViewRow = (GridViewRow)thisTextBox.Parent.Parent;
int row = thisGridViewRow.RowIndex;
rowChanged[row] = true;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
int totalRows = GridView1.Rows.Count;
for (int r = 0; r < totalRows; r++)
{
if (rowChanged[r])
{
GridViewRow thisGridViewRow = GridView1.Rows[r];
HiddenField hf1 = (HiddenField)thisGridViewRow.FindControl("HiddenField1");
string pk = hf1.Value;
TextBox tb1 = (TextBox)thisGridViewRow.FindControl("TextBox1");
string name = tb1.Text;
TextBox tb2 = (TextBox)thisGridViewRow.FindControl("TextBox2");
decimal price = Convert.ToDecimal(tb2.Text);
SqlCommand cmd = new SqlCommand("update items set name='" + name + "' , price='" + price + "' where INTERM_NO=' " + pk + "'", con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
int temp = cmd.ExecuteNonQuery();
if (temp > 0)
{
lblMessage.Text = "Operation perform successfully";
con.Close();
}
}
}
GridView1.DataBind();
BindGrid();
}
}
}
Note: If you have any query or question about this post contact us:
step1-: Create a table with name " items" with following columns("iterm_no","name","price")
where "iterm_no" is identity column.as describe below
create table items
(
iterm_no int identity(1,1),
name varchar(20),
price numeric(10,2)
)
step2- Now create a web page with name(EditableGridView). as describe below.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EditableGridView.aspx.cs" Inherits="EditableGridView" %>
<!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>Editable GridView</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="INTERM_NO" >
<FooterStyle BackColor="White" ForeColor="#000066" />
<Columns>
<asp:BoundField DataField="INTERM_NO" HeaderText="ITEM_N0" InsertVisible="False" ReadOnly="True"
SortExpression="INTERM_NO" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'
OnTextChanged="TextBox_TextChanged" BorderStyle="None"></asp:TextBox>
<asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("INTERM_NO") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PRICE" SortExpression="PRICE">
<ItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("PRICE") %>'
OnTextChanged="TextBox_TextChanged" BorderStyle="None"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
<asp:Button ID="btnUpdate" runat="server" onclick="btnUpdate_Click"
Text="Update" />
<asp:Label ID="lblMessage" runat="server"></asp:Label>
</form>
</body>
</html>
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class EditableGridView : System.Web.UI.Page
{
SqlConnection con;
bool[] rowChanged;
protected void Page_Load(object sender, EventArgs e)
{
string conString = ConfigurationSettings.AppSettings["mycon"];
con = new SqlConnection(conString);
int totalRows = GridView1.Rows.Count;
rowChanged = new bool[totalRows];
if (!Page.IsPostBack)
{
BindGrid();
}
}
public void BindGrid()
{
SqlDataAdapter adap = new SqlDataAdapter("select * from items", con);
DataTable dt = new DataTable();
adap.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void TextBox_TextChanged(object sender, EventArgs e)
{
TextBox thisTextBox = (TextBox)sender;
GridViewRow thisGridViewRow = (GridViewRow)thisTextBox.Parent.Parent;
int row = thisGridViewRow.RowIndex;
rowChanged[row] = true;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
int totalRows = GridView1.Rows.Count;
for (int r = 0; r < totalRows; r++)
{
if (rowChanged[r])
{
GridViewRow thisGridViewRow = GridView1.Rows[r];
HiddenField hf1 = (HiddenField)thisGridViewRow.FindControl("HiddenField1");
string pk = hf1.Value;
TextBox tb1 = (TextBox)thisGridViewRow.FindControl("TextBox1");
string name = tb1.Text;
TextBox tb2 = (TextBox)thisGridViewRow.FindControl("TextBox2");
decimal price = Convert.ToDecimal(tb2.Text);
SqlCommand cmd = new SqlCommand("update items set name='" + name + "' , price='" + price + "' where INTERM_NO=' " + pk + "'", con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
int temp = cmd.ExecuteNonQuery();
if (temp > 0)
{
lblMessage.Text = "Operation perform successfully";
con.Close();
}
}
}
GridView1.DataBind();
BindGrid();
}
}
}
Note: If you have any query or question about this post contact us:
How to get integer and character from input and display them in c
#include<stdio.h>
void main()
{
int r,m;
char variable;
printf("Enter the grad of student");
scanf("%c",&variable);
printf("Enter the roll no of student");
scanf("%d",&r);
printf("Enter the marks of student");
scanf("%d",&m);
// now display the student information
printf("\n");
printf("Rollno of student is %d",r);
printf("\n");
printf("Marks of student is %d",m);
printf("\n");
printf("Grade of student is%c", variable);
}
Subscribe to:
Posts (Atom)