Copy DataList Item on Button Click to GridView in same page using C# and VB.Net in ASP.Net

Hi akhter,

Refer below sample.

HTML

<div>
    <table class="auto-style1">
        <tr>
            <td>
                <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" OnCheckedChanged="Redirect" />
                                                            <asp:Button ID="btnadd" runat="server" Text="Add Cart" OnClick="AddToCart"></asp:Button>
                                                        </li>
                                                    </div>
                                                </ul>
                                            </li>
                                        </ul>
                                    </li>
                                </ul>
                            </div>
                            </div>
                        </ItemTemplate>
                        <FooterTemplate>
                        </FooterTemplate>
                    </asp:DataList>
                </div>
                &nbsp;
            </td>
            <td>
                <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="Name">
                            <ItemTemplate>
                                <asp:Label Text='<%#Eval("Name") %>' runat="server" ID="lblName" />
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="QTY">
                            <ItemTemplate>
                                <asp:TextBox ID="txtqty" runat="server" Height="16px" Width="33px"></asp:TextBox>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;
            </td>
            <td>
                &nbsp;
            </td>
        </tr>
    </table>
</div>

Namespaces

C#

using System.Data.SqlClient;
using System.Configuration;
using System.Data

Code

C#

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 AddToCart(object sender, EventArgs e)
{
    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.tblfilesData";
            sqlBulkCopy.ColumnMappings.Add("Name", "Name");
            sqlBulkCopy.ColumnMappings.Add("Data", "Data");
            con.Open();
            sqlBulkCopy.WriteToServer(dt);
            con.Close();
        }
    }
}

Screenshot