ASP.NET

ItemTemplate>
    <asp:HyperLink ID="hdReserve" class="js_siteid"  AutoPostBack="false" runat="server" Text="Select"
      Navigateurl='<%# String.Format("requestSummary.aspx?id={0}&groupsize={1}&facilityFees={2}&depoitAmt={3}&cancelAmt={4}&keydeptAmt={5}&extrahour={6}&facility={7}&hoursdiff={8}", CType(Container.DataItem, System.Data.DataRowView)("siteId") , ddlPartySize.SelectedValue,CType(Container.DataItem, System.Data.DataRowView)("RentalFeeAmount"),CType(Container.DataItem, System.Data.DataRowView)("DepositAmount"),CType(Container.DataItem, System.Data.DataRowView)("CancellationAmount"),CType(Container.DataItem, System.Data.DataRowView)("DepositAmount"),CType(Container.DataItem, System.Data.DataRowView)("ExtraHourAmount"),CType(Container.DataItem, System.Data.DataRowView)("AssetName"), hf1.Value) %>' />
</ItemTemplate>

'retrieve querystring values for hoursdiff:

'the markup - label control:
 <td style="font-weight:bold"> Extra Hours: <asp:Label ID="lblhourspassedval" runat="server" /></td>

Dim intHours As Integer = 0
intHours = Request.QueryString("hoursdiff")

'Assign intHours to session:
Session("intHours")

Pass the session value back to the label control:
 lblhourspassedval.Text = Session("intHours")

<asp:SqlDataSource ID="MySqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" 

SelectCommand="SELECT * from myTable
       WHERE Active= 'True'
       AND myTable.Project = COALESCE(NULLIF(@FindProject, ''), myTable.Project)">
    &lt;SelectParameters>
    <asp:ControlParameter ControlID="FindProject" Name="FindProject"
        PropertyName="Text" />
    &lt;/SelectParameters>

[Window Title]
Visual Studio Just-In-Time Debugger

[Main Instruction]
An unhandled Microsoft .NET Framework exception occurred in w3wp.exe [3596].

The Just-In-Time debugger was launched without necessary security permissions. To debug this process, the Just-In-Time debugger must be run as an Administrator. Would you like to debug this process?

[V] View process details  [Yes, debug w3wp.exe] [No, cancel debugging]

[Expanded Information]
Process Name: w3wp.exe
User Name: IIS APPPOOL\ELMS [Elevated]

Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2
Faulting module name: clr.dll, version: 4.0.30319.18444, time stamp: 0x52717f9a
Exception code: 0xc00000fd
Fault offset: 0x0000000000009f66
Faulting process id: 0x141c
Faulting application start time: 0x01d07b8b53af8a8c
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
Report Id: a1f85976-e77e-11e4-8858-08002703e456

private void button2_Click(object sender, EventArgs e)
        {
            using (SqlConnection sqlConn = new SqlConnection(@"Data Source=BBATRIDIP\SQLSERVER2008R2;Initial Catalog=test;Integrated Security=True"))
            {
                string query = String.Format(@"SELECT [FilePath],[FileName],[FileData] FROM [TestTable]");
                SqlCommand cmd = new SqlCommand(query, sqlConn);
                cmd.Connection.Open();

                System.IO.MemoryStream memStream = null;
                ZipFile zip = new ZipFile();
                zip.MaxOutputSegmentSize = 1024 * 1024; // 1MB each segment size would be
                // the above line would split zip file into multiple files and each file
                //size would be 1MB
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        byte[] data = (byte[])reader["FileData"];
                        memStream = new System.IO.MemoryStream(data);
                        string strFile = reader["FilePath"].ToString() + "\\" + reader["FileName"].ToString();
                        ZipEntry ze = zip.AddEntry(strFile, memStream);
                    }
                }
                zip.Save(@"e:\MyCustomZip.zip");
                memStream.Dispose();
                MessageBox.Show("Job Done");
                // here u can save the zip in memory stream also there is a overload insteaa of saving in HD
            }
        }

MemoryStream stream = new MemoryStream(); 
dt.WriteXml(stream); 
stream.Seek(0,SeekOrigin.Begin);   // <-- must do this after writing the stream!

using (ZipFile zipFile = new ZipFile())
{
  zipFile.AddEntry("Report.xml", "", stream); 
  Response.ClearContent(); 
  Response.ClearHeaders(); 
  Response.AppendHeader("content-disposition", "attachment; filename=Report.zip"); 

  zipFile.Save(Response.OutputStream); 
}

byte[] data = (byte[])reader["FileData"];
memStream = new System.IO.MemoryStream(data);