. aspx page
Code File:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient ;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class DataListOne : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("trusted_connection=true;database=Hardware");
SqlDataAdapter da = new SqlDataAdapter("select * from table1", con);
DataTable dt = new DataTable();
da.Fill(dt );
DataList1.DataSource = dt;
DataList1.DataBind();
}
protected void ItemName(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "View")
{
string name = (e.CommandArgument).ToString();
Session["Name"] = name;
Response.Redirect("DisplayDataListRecord.aspx");
}
}
}
Source
<asp:DataList ID="DataList1" runat="server" RepeatColumns ="3"
RepeatDirection="Vertical" OnItemCommand="ItemName"
>
<ItemTemplate >
<img src='<%#Eval("Image") %>' alt ="Image not found" height ="150" width ="150" /><br />
<%#Eval("Name") %> <br />
<%#Eval("Price") %><br />
<asp:LinkButton ID="LinkButto1" runat ="server" Text="View" CommandName ="View" CommandArgument='<%#Eval("Name") %>'>
</asp:LinkButton>
<br />
</ItemTemplate>
</asp:DataList>
.aspx page II
Code File:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data .SqlClient ;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class DisplayDataListRecord : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("trusted_connection=true;database=hardware");
SqlDataAdapter da = new SqlDataAdapter("Select * from table1 where Name='" + Session["Name"] + "' ", con);
DataSet dt=new DataSet ();
da.Fill(dt);
DataList1.DataSource = dt ;
DataList1 .DataBind ();
}
}
Source
<asp:DataList ID="DataList1" runat="server" RepeatColumns ="2" RepeatDirection="Vertical">
<ItemTemplate>
<img src='<%#Eval("Image") %>' alt ="Image Not found" runat ="server" height ="200" width ="200" /><br />
<%#Eval("Name") %><br />
<%#Eval ("Price") %><br /><br />
</ItemTemplate>
</asp:DataList>