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);

<ol>
    <li id="first-option" class="first-option">
        <div class="paren"></div>
        <div class="full col">
            <label for="txtFirstName">First Name</label>
            <asp:TextBox ID="txtFirstName" runat="server" ClientIDMode="Static" Enabled="false" />
        </div>

        <div class="full col">
            <label for="txtLastName">Last Name</label>
            <asp:TextBox ID="txtLastName" runat="server" ClientIDMode="Static" Enabled="false" />
        </div>

        <div class="full col">
            <label for="txtBirthDate">Date of Birth</label>
            <elms:DateTextBox ID="txtBirthDate" runat="server" ClientIDMode="Static" />
        </div>

        <div class="full col">
            <label for="txtEmailAddress">Email Address</label>
            <asp:TextBox ID="txtEmailAddress" runat="server" ClientIDMode="Static" />
        </div>

        <div class="full col">
            <label for="txtEmailAddress2">Verify Email Address</label>
            <asp:TextBox ID="txtEmailAddress2" runat="server" ClientIDMode="Static" />
        </div>
    </li>

    <li id="or-divider" class="or-divider"><span></span></li>
    <li id="second-option" class="second-option">
        <div class="paren"></div>
        <div class="full col">
            <label for="txtStarsId" runat="server">STARS ID</label>
            <asp:TextBox ID="txtStarsId" runat="server" ClientIDMode="Static" />
        </div>
    </li>
</ol>
<div class="action-buttons">
    <asp:Button ID="btnSave" ClientIDMode="Static" runat="server" Text="Save" />
    <asp:Button ID="btnCancel" ClientIDMode="Static" runat="server" Text="Cancel" />
</div>

or-divider 
{
    position:absolute;
    border:none;
    left:50%;
    top:50%;
    transform:translate(-50%,-50%);
}

.or-divider > span
{
    background:transparent url('../../../images/OR-Small.png') no-repeat top center;
    background-color:White;
    position:absolute;
    font-size:1.3em;
    font-weight:bold;
    top: inherit;
    display: inline-block;
    left: 40%;
    height:20px;
    width:80px;
    z-index:1000;
}

<h1>or-divider + li</h1>

{
    padding-top:30px;
}

.my-container > ol > li > span:first-child 
{
    display:block;
    margin-bottom:5px;
}

.my-container > ol > li:first-child > select,
.my-container > ol > li:first-child > .chosen-container
{
    width:100%;
    margin-bottom:5px;
}

div.paren 
{
    position:absolute;
    left:25px;
    top:0;
    height:47px;
    width:15px;
    background:transparent url('../../../images/Close-Paren.png') no-repeat left top;
}

<h1>first-option,</h1>

<h1>second-option</h1>

{
    position:relative;
    padding-left:50px;
}

<h1>first-option</h1>

{
    background:transparent url('../../../images/1.png') no-repeat 2px 3px;
}

<h1>second-option</h1>

{
    min-height:40px;
    background:transparent url('../../../images/2.png') no-repeat left 33px;
}

<h1>second-option div.paren</h1>

{
    background-position:left 30px;
    height:77px;
}