Introduction: In
this article I have explained how we can Bind, Edit, Update and Delete in Gridview
using three tier architecture in Asp.net.
Description:
In the last I have explained How to insert Data intoDatabase using three tier architecture in Asp.net and How to bind data to Gridview in Three-Tier Architecture in asp.net using SqlHelper.
I have a Table USER_REGISTRATION:
ID
|
int
|
USERNAME
|
varchar(50)
|
PASSWORD
|
varchar(50)
|
FIRST_NAME
|
varchar(50)
|
LAST_NAME
|
varchar(50)
|
SEX
|
varchar(50)
|
EMAIL_ID
|
varchar(50)
|
Here ID is autoincrement and primary key.
Create a Store
Procedure to Delete the Records:
CREATE PROCEDURE [dbo].[DELETE_USER]
(
@ID INT
)
AS
BEGIN
SET NOCOUNT
ON;
DELETE FROM dbo.USER_REGISTRATION
WHERE ID = @ID
END
Create a Store
Procedure to Update the Records/Data:
CREATE PROCEDURE [dbo].[UPDATE_USER]
(
@ID INT,
@USERNAME varchar(50),
@FIRST_NAME varchar(50),
@LAST_NAME varchar(50),
@EMAIL_ID varchar(50),
@SEX VARCHAR(50)
)
AS
BEGIN
SET NOCOUNT
ON;
UPDATE dbo.USER_REGISTRATION SET
USERNAME= @USERNAME,
FIRST_NAME=@FIRST_NAME,
LAST_NAME=@LAST_NAME,
EMAIL_ID=@EMAIL_ID,
SEX=@SEX
WHERE ID=@ID
END
Add a new Class to clsuserRegistartion.cs
to Bussiness Layer (DataEntities) of Project:
public class clsuserRegistartion
{
public int ID {get;set;}
public string
USERNAME { get; set;
}
public string
PASSWORD { get; set;
}
public string
FIRST_NAME { get; set;
}
public string
LAST_NAME { get; set;
}
public string SEX { get; set; }
public string
EMAIL_ID { get; set;
}
}
.png)
