GridView nested inside another GridView in ASP.NET

Download Files:

• NestedGridView.zip

 

Tables:

Create Database with the name as "NestedGridView" and create following tables in that database.


Stored Procedures:

Create Procedure sp_GetFileDetails
(
@FileId int
)
AS
Begin
select * from tbl_Files where FileId = @FileId
End

Create procedure sp_GetFilesFromCart
As
begin
select * from tbl_Cart c inner join tbl_Files f on
f.FileId = c.FileId
end

Create procedure sp_GetPrintSize
As
Begin
select * from tbl_PrintSize
End

Web.config:

       <connectionStrings>
              <add name="constr" connectionString="User Id = sa; Password = 123; Database = NestedGridView; Data Source = server2"/>
       </connectionStrings>

Classes:

1. Connection Class:

public class Connection
{
       public static string GetConnectionString()
    {
        return ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    }
}

2. Data Access Layer Class:

public class DAL
{
       static SqlConnection con;
    static SqlCommand cmd;
    static DataSet ds;
    static SqlDataAdapter da;

    public static DataSet ExecuteDataSet(string connectionString, CommandType commandType, string commandText,SqlParameter[] parameters)
    {
        try
        {
            con = new SqlConnection(connectionString);
            cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = commandText;
            cmd.CommandType = commandType;
            if (parameters == null)
            {
                da = new SqlDataAdapter(cmd);
                ds = new DataSet();
                da.Fill(ds);
                return ds;
            }
            else
            {
                foreach (SqlParameter p in parameters)
                {
                    if ((p.Direction == ParameterDirection.InputOutput) && (p.Value == null))
                    {
                    }
                        cmd.Parameters.Add(p);
                }
                da = new SqlDataAdapter(cmd);
                ds = new DataSet();
                da.Fill(ds);
                return ds;
            }
        }
        catch (SqlException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }

}

3. Business Object Layer Class:

public class BOL
{
       public static DataSet GetFilesFromCart()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[0];
            return DAL.ExecuteDataSet(Connection.GetConnectionString(), CommandType.StoredProcedure, "[sp_GetFilesFromCart]", p);
        }
        catch (Exception ex) { throw new ArgumentException(ex.Message); }
    }

    public static DataSet GetPrintSize()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[0];
            return DAL.ExecuteDataSet(Connection.GetConnectionString(), CommandType.StoredProcedure, "sp_GetPrintSize", p);
        }
        catch (Exception ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }

    public static DataSet GetFileDetails(int fileId)
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];
            p[0] = new SqlParameter("@FileId", fileId);
            return DAL.ExecuteDataSet(Connection.GetConnectionString(), CommandType.StoredProcedure, "sp_GetFileDetails", p);
        }
        catch (Exception ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
}

Default.aspx Page Source Code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                    ShowHeader="true" 
                     Width="500px"
                    onrowdatabound="GridView1_RowDataBound">
                <Columns>
               <asp:TemplateField  ItemStyle-BorderStyle="None" HeaderText="S No"  ItemStyle-Font-Bold="true">
                <ItemTemplate>
                <%# Container.DataItemIndex + 1  %>
                </ItemTemplate>
                </asp:TemplateField>
               <asp:TemplateField HeaderText="Selected Photos">
               <ItemTemplate>
                    <table>
               <tr>
               <td valign="middle">
               <asp:ImageButton ID="ImageButton1" Enabled="false"  CommandName="selectedimg" ImageUrl='<%# "~/Thumbnail.ashx?fileId="+Eval("FileId") %>' CommandArgument='<%# Eval("FileId") %>' runat="server">
                   </asp:ImageButton>
               </td>
               </tr>
               </table>
               </ItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Print Options">
               <ItemTemplate>
                   <asp:GridView ID="GridView2" runat="server" ShowHeader="true" Width="300px" AutoGenerateColumns="false">
                   <Columns>
                   <asp:TemplateField HeaderText="Qty">
                   <ItemTemplate>
                   <asp:TextBox ID="TextBox1" MaxLength="3" ValidationGroup="add"  Width="35" onkeydown="return CheckKeyCode()" runat="server"></asp:TextBox>
                   </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="Size">
                   <ItemTemplate>
                   <asp:LinkButton ID="LinkButton1" ForeColor="AliceBlue" CommandName="lbtnsize" Enabled="false" Text='<%# Eval("SizeName") %>' CommandArgument='<%# Eval("SizeId") %>' runat="server"></asp:LinkButton>
                   </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="Price(1 Qty)">
                   <ItemTemplate>
                   <asp:LinkButton ID="LinkButton2" ForeColor="AliceBlue" Text='<%# Eval("Price") %>' Enabled="false" CommandName="lbtnprice" CommandArgument='<%# Eval("SizeId") %>' runat="server"></asp:LinkButton>

                   </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="TotalPrice">
                   <ItemTemplate>
                   <asp:Label ID="Label2" runat="server" Text=""></asp:Label>
                   </ItemTemplate>
                   </asp:TemplateField>
                   </Columns>
                   </asp:GridView>
               </ItemTemplate>
               </asp:TemplateField>
                </Columns>
                </asp:GridView>

Default.aspx.cs CodeBehind:

protected void Page_Load(object sender, EventArgs e)    {
        if (!IsPostBack)
        {
            DataSet ds = BOL.GetFilesFromCart();
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            GridView gv = (GridView)e.Row.FindControl("GridView2");
            DataSet ds1 = BOL.GetPrintSize();
            ImageButton ib = (ImageButton)e.Row.FindControl("ImageButton1");
            gv.DataSource = ds1;
            gv.DataBind();
        }
    }

Thumbnail.ashx:

 <%@ WebHandler Language="C#" Class="Thumbnail" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;

public class Thumbnail : IHttpHandler {

       public void ProcessRequest (HttpContext context) {
        if (context.Request.QueryString["fileId"].ToString() == "")
        { }
        else
        {
            int fileId = Convert.ToInt32(context.Request.QueryString["fileId"]);
            if (fileId != 0)
            {
                DataSet ds = BOL.GetFileDetails(fileId);
                if (ds.Tables[0].Rows[0]["FileContent"] != System.DBNull.Value)
                {
                    byte[] image = (byte[])ds.Tables[0].Rows[0]["FileContent"];
                    System.IO.MemoryStream ms = new System.IO.MemoryStream();
                    ms.Write(image, 0, image.Length);
                    context.Response.Buffer = true;
                    if (image.Length != 0)
                    {
                        Bitmap loBMP = new Bitmap(ms);
                        int wid = loBMP.Width;
                        if (wid > 120) { wid = 120; }
                        int hei = loBMP.Height;
                        if (hei > 100) { hei = 100; }
                        Bitmap bmpOut = new Bitmap(wid, hei);
                        Graphics g = Graphics.FromImage(bmpOut);
                        g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
                        g.FillRectangle(Brushes.White, 0, 0, wid, hei);
                        g.DrawImage(loBMP, 0, 0, wid, hei);
                        MemoryStream ms2 = new MemoryStream();
                        bmpOut.Save(ms2, System.Drawing.Imaging.ImageFormat.Jpeg);
                        byte[] bmpBytes = ms2.GetBuffer();
                        bmpOut.Dispose();
                        ms2.Close();
                        context.Response.Clear();
                        context.Response.BinaryWrite(bmpBytes);
                        context.Response.End();
                    }
                    ms.Dispose();
                }
            }
        }
    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}