ASP.NET

try
{
    // a bunch of code, database stuff, etc.

    Response.Redirect("somePage.aspx");
}
catch (Exception ex)
{
   // Error Logging
}
finally
{
    // object cleanup and disposal
}

private void DisplayData(int startRow)
    {
      using (Origo.Vefur.Linq.dbMainDataContext db = new Linq.dbMainDataContext(Origo.WMMain.Helpers.Global.ConnectionString))
      {

        var empList = from el in db.owm_USERs
                      where el.showOnWeb == 1
                      select el;

        //ListView1.DataSourceID(employeeList);
        ListView1.DataSource = empList.Skip(startRow).Take(10);
        ListView1.DataBind();
      }
    }

<asp:ListView ID="ListView1" runat="server"
      onselectedindexchanged="ListView1_SelectedIndexChanged1"
      onsorted="ListView1_Sorted" onsorting="ListView1_Sorting">
      <LayoutTemplate>
        <table id="Table1" runat="server" class="TableCSS">
          <tr id="Tr1" runat="server" class="table-header">
            <th align="left"><asp:LinkButton ID="lnkID" CommandArgument="id" CommandName="Sort" Text="id" runat="server" /></th>
            <th align="left"><asp:LinkButton ID="lnkName" runat="server">Nafn</asp:LinkButton></th>
            <th align="left">
              <asp:dropdownlist runat="server" id="ddlWrokplace"
                  DataTextField="workplace" DataValueField='<%# Eval("workplace") %>' SelectedValue='<%# Eval("workplace") %>'></asp:dropdownlist>
            </th>

Using _databasefactory As New DatabaseFactory()
     Dim context = _databasefactory.DatabaseContext

     If Not String.IsNullOrEmpty(temp_doc_id) AndAlso Not String.IsNullOrEmpty(doc_id) Then
         Dim reqs = (From r In context.requests Where r.claim.claim_no.Equals(claim_no) AndAlso r.temp_doc_id.Equals(r.temp_doc_id)) 'r.empl_accnt_no.Equals(emplacctnumber) AndAlso _

         Dim res = 0
         If reqs Is Nothing Then
             Dim rq = New request()
             rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
             rq.empl_accnt_no = emplacctnumber
             rq.manual_claim_no = ManualClaimNo
             rq.doc_id = doc_id
             rq.temp_doc_id = temp_doc_id
             rq.request_status = "OANEW"
             rq.last_update_ts = DateTime.Now
             rq.create_ts = DateTime.Now
             rq.comments = String.Empty
             context.AddTorequests(rq)
             Return context.SaveChanges()
         ElseIf reqs.Count() <= 0 Then
             Dim rq = New request()
             rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
             rq.empl_accnt_no = emplacctnumber
             rq.manual_claim_no = ManualClaimNo
             rq.doc_id = doc_id
             rq.temp_doc_id = temp_doc_id
             rq.request_status = "OANEW"
             rq.last_update_ts = DateTime.Now
             rq.create_ts = DateTime.Now
             rq.comments = String.Empty
             context.AddTorequests(rq)
             Return context.SaveChanges()
         Else
             Dim rq = reqs.FirstOrDefault()
             'If Not rq.claimReference.IsLoaded Then
             '    rq.claimReference.Load()
             'End If
             rq.doc_id = doc_id
             res = context.SaveChanges()
             Return res
         End If
     End If
 End Using