Datalist with coding

1) For working on DataList first You need to make the database as in our site we already show you how to make the database.

2) HTML Source code for design of DataList

Click here to see the code

Properties set for DataList

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 datalst : 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);

DataList1.DataSource = ds;

DataList1.DataBind();

}

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e) //Event of DataList

{

DataList1.EditItemIndex = e.Item.ItemIndex;

sunny();

}

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) //Event of DataList

{

Int32 bid;

bid = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);

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();

sunny();

}

protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) //Event of DataList

{

Int32 prc,bid;

string tit, aut, img, pub;

bid = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);

tit = ((TextBox)(e.Item.FindControl("txttit"))).Text;

aut = ((TextBox)(e.Item.FindControl("txtaut"))).Text;

img = ((TextBox)(e.Item.FindControl("txtimg"))).Text;

pub = ((TextBox)(e.Item.FindControl("txtpub"))).Text;

prc =Convert.ToInt32( ((TextBox)(e.Item.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 = bid;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

DataList1.EditItemIndex = -1;

sunny();

}

protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e) //Event of DataList

{

DataList1.EditItemIndex = -1;

sunny();

}

}

Running interface Demo of DataList with coding

******************************************************************************