Hi akhter,
Refer below sample.
HTML
<div>
<asp:DataList ID="dlemp" runat="server" RepeatDirection="Horizontal" RepeatColumns="2">
<ItemTemplate>
<div id="pricePlans">
<ul id="plans">
<li class="plan">
<ul class="planContainer">
<li class="title">
<h2>
<asp:Label ID="ProductName" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
<br />
</li>
<li class="title">
<asp:Image ID="imgEmp" Height="100px" Width="100px" runat="server" ImageUrl='<%# "data:image/jpg;base64," + Convert.ToBase64String((byte[])Eval("Data")) %>' />
</li>
<li>
<ul class="options">
<div>
<li><b>Id: </b>
<asp:Label ID="CustomerID" runat="server" Text=' <%# Eval("Id") %>'></asp:Label>
<asp:CheckBox ID="CheckBox1" runat="server" Text="select" />
</li>
</div>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
</ItemTemplate>
<FooterTemplate>
</FooterTemplate>
</asp:DataList>
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="Redirect">ViewDeatils</asp:LinkButton>
<asp:LinkButton Text="CheckOut" runat="server" OnClick="CheckOut" />
</div>
ViewDetails.aspx
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="Image">
<ItemTemplate>
<asp:Image ID="Data" runat="server" Width="100px" Height="80px" ImageUrl='<%# "data:image/jpg;base64," + Convert.ToBase64String((byte[])Eval("Data")) %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Image">
<ItemTemplate>
<asp:Label Text='<%#Eval("Name") %>' runat="server" ID="lblName" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
<asp:Button Text="Save" runat="server" OnClick="Save" />
</div>
Namespaces
C#
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
VB.Net
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Data
Code
C#
CS.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string query = "SELECT top 4 * FROM tblfiles WHERE ContentType='image/pjpeg'";
DataTable dt = GetData(query);
dlemp.DataSource = dt;
dlemp.DataBind();
}
}
private static DataTable GetData(string query)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
protected void Redirect(object source, EventArgs e)
{
string id = "";
foreach (DataListItem item in dlemp.Items)
{
CheckBox chk = item.FindControl("CheckBox1") as CheckBox;
if (chk.Checked)
{
id += (item.FindControl("CustomerID") as Label).Text + ",";
}
}
string query = "SELECT * FROM tblfiles where Id IN(" + id.TrimEnd(',') + ")";
DataTable dt = GetData(query);
Session["dt"] = dt;
}
protected void CheckOut(object sender, EventArgs e)
{
Response.Redirect("ViewDetails.aspx");
}
ViewDetails.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = Session["dt"] as DataTable;
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
protected void Save(object sender, EventArgs e)
{
DataTable dt = Session["dt"] as DataTable;
string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
sqlBulkCopy.DestinationTableName = "dbo.tblfiles";
sqlBulkCopy.ColumnMappings.Add("Name", "Name");
sqlBulkCopy.ColumnMappings.Add("Data", "Data");
con.Open();
sqlBulkCopy.WriteToServer(dt);
con.Close();
}
}
}
VB.Net
VB.aspx.vb
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handle Me.Load
If Not Me.IsPostBack Then
Dim query As String = "SELECT top 4 * FROM tblfiles WHERE ContentType='image/pjpeg'"
Dim dt As DataTable = GetData(query)
dlemp.DataSource = dt
dlemp.DataBind()
End If
End Sub
Private Shared Function GetData(ByVal query As String) As DataTable
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Dim con As SqlConnection = New SqlConnection(constr)
Dim cmd As SqlCommand = New SqlCommand(query, con)
Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim dt As DataTable = New DataTable()
da.Fill(dt)
Return dt
End Function
Protected Sub Redirect(ByVal source As Object, ByVal e As EventArgs)
Dim id As String = ""
For Each item As DataListItem In dlemp.Items
Dim chk As CheckBox = TryCast(item.FindControl("CheckBox1"), CheckBox)
If chk.Checked Then
id += (TryCast(item.FindControl("CustomerID"), Label)).Text & ","
End If
Next
Dim query As String = "SELECT * FROM tblfiles where Id IN(" & id.TrimEnd(","c) & ")"
Dim dt As DataTable = GetData(query)
Session("dt") = dt
End Sub
Protected Sub CheckOut(ByVal sender As Object, ByVal e As EventArgs)
Response.Redirect("ViewDetails.aspx")
End Sub
ViewDetailsVB.aspx.vb
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handle Me.Load
If Not Me.IsPostBack Then
Dim dt As DataTable = TryCast(Session("dt"), DataTable)
GridView1.DataSource = dt
GridView1.DataBind()
End If
End Sub
Protected Sub Save(ByVal sender As Object, ByVal e As EventArgs)
Dim dt As DataTable = TryCast(Session("dt"), DataTable)
Dim consString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(consString)
Using sqlBulkCopy As SqlBulkCopy = New SqlBulkCopy(con)
sqlBulkCopy.DestinationTableName = "dbo.tblfiles"
sqlBulkCopy.ColumnMappings.Add("Name", "Name")
sqlBulkCopy.ColumnMappings.Add("Data", "Data")
con.Open()
sqlBulkCopy.WriteToServer(dt)
con.Close()
End Using
End Using
End Sub
