---
title: "DetailsView Control in ASP.Net"
description: "The DetailsView control displays a single record from a data source, where each data row represents a field in the record. The DetailsView control gi"
author: "Pushpendra Singh"
published: 2010-10-30
updated: 2020-03-04
canonical: https://www.mindstick.com/articles/186/detailsview-control-in-asp-dot-net
category: "ado.net"
tags: ["ado.net"]
reading_time: 5 minutes
---
# DetailsView Control in ASP.Net
The DetailsView control displays a single record from a data source, where each data row represents a field in the record.\
The DetailsView control gives you the ability to display, edit, insert, or delete a single record at a time from its associated data source.
```
```
\
## Code:
```
| | ID | Password | NAME | edit | delete |
update cancel
ADD
```
*<%#DataBinder.Eval(Container.DataItem,"name") %>* DataBinder.Eval takes the argument. The first arg is the data object to bind to. The second arg is the string name of the field which will display on the page.
## Bind Data in DetailsView:
```
protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack) {Binddata();// this function is called when the page is loaded. }} public void Binddata(){DataSet ds = new DataSet(); DetailsView1.DataSource = Class1.execute_fill_datalist("insert_reg");// Here data is fetched from the database through stored procedure(insert_reg). DetailsView1.DataBind();//Here data is bind to the control and show on the page.}
```
In above code execute_fill_datalist is a function created in Class1.cs which is described below.
And insert_reg is a stored procedure made in backend.Which is described below
**Allow paging should be true.**
```
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e){ DetailsView1.PageIndex = e.NewPageIndex; Binddata();}
```
\
## EditMode:
DetailsView has ModeChanging event by which you can change normal mode to edit mode .In ths event we can also cancel edit mode.
```
protected void DetailsView1_ModeChanging(object sender, DetailsViewModeEventArgs e){ DetailsView1.ChangeMode(DetailsViewMode.Edit); Binddata(); if (e.CancelingEdit == true) { Response.Redirect("Default.aspx");// redirect to the Default.aspx page }}
```
## Add, Update and Delete in DetailsView:
ItemCommand event is used for programmatically determining which specific command button is clicked and take appropriate action.
Here this event is used for Adding data
```
protected void DetailsView1_ItemCommand(object sender, DetailsViewCommandEventArgs e){if (e.CommandName == "ADD"){// Here FindControl will find the TextboxId in which adding will be done. TextBox l = DetailsView1.FindControl("TextBox3") as TextBox; string i = l.Text; TextBox a = DetailsView1.FindControl("TextBox4") as TextBox; string p = a.Text; TextBox b = DetailsView1.FindControl("TextBox5") as TextBox; string s = b.Text; Class1.updat_reg("add_reg", i, p, s); Response.Redirect("Default.aspx"); Binddata(); }}
```
ItemUpdating event is used to update data
```
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e){// Here FindControl will find the Textbox in which updating will be done. TextBox l = DetailsView1.FindControl("txt1") as TextBox;string i = l.Text;TextBox a = DetailsView1.FindControl("TextBox1") as TextBox;string p = a.Text;TextBox b = DetailsView1.FindControl("TextBox2") as TextBox;string s = b.Text; Class1.updat_reg("update_reg", i, p, s);// update_reg is a function which fetch the data from database through stored procedure. Response.Redirect("Default.aspx"); Binddata();}
```
\
ItemDeleting event is used to delete data.
```
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e){Label lb = DetailsView1.FindControl("lbl1") as Label; string b = lb.Text;Class1.delete_regform("del_reg", b);// Here delete_regform is a function. It gets the data which will be deleted from database through stored procedure. Binddata();}
```
Add both namespace in every .cs page in which you want to use data and SQL related keyword
```
using System.Data;using System.Data.SqlClient;
```
## Class1.cs
```
using System;using System.Collections.Generic;using System.Linq;using System.Data.SqlClient;using System.Data;using System.Web; public class Class1{ public static DataSet execute_fill_datalist(string spname)// this function is used to bind data {SqlConnection con = Connection.CreateConnection();DataSet ds = new DataSet();SqlCommand cmd = new SqlCommand();cmd.CommandText = spname;cmd.CommandType = CommandType.StoredProcedure;cmd.Connection = con;con.Open(); SqlDataAdapter da = new SqlDataAdapter(spname, con);da.Fill(ds); return ds; } public static void updat_reg(string spname,string id,string ps,string nm)// this function is used to update and add data {SqlConnection con=Connection.CreateConnection();SqlCommand cmd = new SqlCommand();cmd.CommandText = spname;cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.Add("@id", SqlDbType.VarChar).Value = id;cmd.Parameters.Add("@pass", SqlDbType.VarChar).Value = ps;cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = nm; cmd.Connection = con;con.Open();cmd.ExecuteNonQuery(); } public static void delete_regform(string spname, string id) // this function is used to delete data {SqlConnection con = Connection.CreateConnection();SqlCommand cmd = new SqlCommand();cmd.CommandText = spname;cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.Add("@id", SqlDbType.VarChar).Value = id; cmd.Connection = con;con.Open();cmd.ExecuteNonQuery(); }}
```
## In class1.cs Connection keyword is used
**Connection is class in whichCreateConnection function is created.**
**Connection.cs**
```
using System;using System.Collections.Generic;using System.Linq;using System.Configuration;using System.Web;using System.Data;using System.Data.SqlClient; public class Connection{ public static SqlConnection CreateConnection() {string connectionstring;connectionstring = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;SqlConnection sqlcon = new SqlConnection(connectionstring);return sqlcon; } }
```
mycon is connection object created in web.config
**web.config:**
```
```
Write this connection string above
## Stored procedure:
This procedure is used to select data
```
Create procedure insert_reg asbeginselect * from regformend
```
This procedure is used to Add data
```
Create procedure add_reg@id varchar(50),@pass varchar(50),@name varchar(50)asbegininsert into regform(id,pass,name)values(@id,@pass,@name)End
```
This procedure is used to Delete data
```
create procedure del_reg@id varchar(50)asbegindelete from regform where id=@idend
```
This procedure is used to Update data
```
create procedure [dbo].[update_reg]@id varchar(50),@pass varchar(50),@name varchar(50)asbeginupdate regform set pass=@pass,name=@name where id=@idend
```
---
Original Source: https://www.mindstick.com/articles/186/detailsview-control-in-asp-dot-net
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.