Detail view with coding

1) Design of Detail view to see HTML code click here.....

2) Properties set for Detail view

3) Events applied in Detail view

4) Code for .aspx

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

public partial class detailvw_WC : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

if (con.State == ConnectionState.Closed)

con.Open();

if (!Page.IsPostBack)

sunny();

}

public void sunny()

{

SqlDataAdapter adp = new SqlDataAdapter("select * from tblbook", con);

DataSet ds = new DataSet();

adp.Fill(ds);

DetailsView1.DataSource = ds;

DetailsView1.DataBind();

}

protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) // event of detail view

{

Int32 bid;

bid = Convert.ToInt32(((Label)(DetailsView1.FindControl("lblbid"))).Text);

SqlCommand cmd = new SqlCommand("delete from tblbook where bookid=@bid", con);

cmd.Parameters.Add("@bid", SqlDbType.Int).Value = bid;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

DetailsView1.PageIndex = -1;

sunny();

}

protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e) // event of detail view

{

DetailsView1.PageIndex = e.NewPageIndex;

sunny();

}

protected void DetailsView1_ModeChanging(object sender, DetailsViewModeEventArgs e) // event of detail view

{

if (e.NewMode == DetailsViewMode.Edit)

DetailsView1.ChangeMode(DetailsViewMode.Edit);

else if (e.NewMode == DetailsViewMode.Insert)

DetailsView1.ChangeMode(DetailsViewMode.Insert);

else

DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);

sunny();

}

protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) // event of detail view

{

Int32 prc;

string tit, aut, img, pub;

tit = ((TextBox)(DetailsView1.FindControl("txttit"))).Text;

aut = ((TextBox)(DetailsView1.FindControl("txtaut"))).Text;

img = ((TextBox)(DetailsView1.FindControl("txtimg"))).Text;

pub = ((TextBox)(DetailsView1.FindControl("txtpub"))).Text;

prc = Convert.ToInt32(((TextBox)(DetailsView1.FindControl("txtprc"))).Text);

SqlCommand cmd = new SqlCommand("update tblbook set booktit=@tit, bookaut=@aut,bookimg=@img,bookpub=@pub,bookprc=@prc where bookid=@bid", con);

cmd.Parameters.Add("tit", SqlDbType.VarChar).Value = tit;

cmd.Parameters.Add("aut", SqlDbType.VarChar).Value = aut;

cmd.Parameters.Add("img", SqlDbType.VarChar).Value = img;

cmd.Parameters.Add("pub", SqlDbType.VarChar).Value = pub;

cmd.Parameters.Add("prc", SqlDbType.Int).Value = prc;

cmd.Parameters.Add("bid", SqlDbType.Int).Value = e.Keys[0].ToString();

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);

sunny();

}

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) // event of detail view

{

Int32 prc,bid;

string tit, aut, img, pub;

bid = Convert.ToInt32(((TextBox)(DetailsView1.FindControl("txtbid"))).Text);

tit = ((TextBox)(DetailsView1.FindControl("txttit"))).Text;

aut = ((TextBox)(DetailsView1.FindControl("txtaut"))).Text;

img = ((TextBox)(DetailsView1.FindControl("txtimg"))).Text;

pub = ((TextBox)(DetailsView1.FindControl("txtpub"))).Text;

prc = Convert.ToInt32(((TextBox)(DetailsView1.FindControl("txtprc"))).Text);

SqlCommand cmd = new SqlCommand("insert into tblbook(bookid,booktit,bookaut,bookimg,bookpub,bookprc) values(@bid,@tit,@aut,@img,@pub,@prc)", con);

cmd.Parameters.Add("@tit", SqlDbType.VarChar).Value = tit;

cmd.Parameters.Add("@aut", SqlDbType.VarChar).Value = aut;

cmd.Parameters.Add("@img", SqlDbType.VarChar).Value = img;

cmd.Parameters.Add("@pub", SqlDbType.VarChar).Value = pub;

cmd.Parameters.Add("@prc", SqlDbType.Int).Value = prc;

cmd.Parameters.Add("@bid", SqlDbType.Int).Value = bid;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);

sunny();

}

}

***************** Web config Code**************************

5) Running interface