ASP.NET

public static string LoggedInUserName
{
  get
  {
     return HttpContext.Current.User.Identity.Name;
  }
}

//------------  HTML Header Code  -----------------------------

<script src="jquery-1.6.2.js" type="text/javascript"></script>     
<script src="jquery.uploadify.v2.1.4.min.js" type="text/javascript"></script>     
<script src="swfobject.js" type="text/javascript"></script>      
<script type="text/javascript">         
$(document).ready(function() {             
$('#file_upload').uploadify({                 
'uploader': '/uploadify.swf',                 
'script': '/Handler1.ashx',                
 'folder': '/uploads',                 
'onAllComplete': function() {                     
if (window.frozenImageEditorToolBar) {                         
$(window.frozenImageEditorToolBar).removeAttr('freeze');                         $(window.frozenImageEditorToolBar).fadeOut();                        
 window.frozenImageEditorToolBar = false;                     
}                 
}            
});              

$('#container').mouseenter(function() {                 
$('#toolbar').fadeIn();             
});             
 $('#container').mouseleave(function() {                
 if (!$('#toolbar').hasAttr('freeze'))                     
$('#toolbar').fadeOut();             
});              
$('#toolbar').mousedown(function(e) {                 
$(this).attr('freeze', '1');                 
window.frozenToolBar = $(this);                 
//prevent container.mouseleave() from fading out the toolbar                 
//until the upload is complete. (see onAllComplete)             
});          
});          
(function($) {             
$.fn.hasAttr = function(attribute) {                 
var attr = this.attr(attribute);                 
return (typeof attr !== 'undefined' && attr !== false);             
}         
})(jQuery);      
</script>      
       

//-------- HTML Body Code --------
<div id="container" style="height: 150px; width: 250px; background-color: #6699FF;">         
<div id="toolbar" style="background-color: #C0C0C0; display: none;">             
<input id="file_upload" type="file" />         
</div>     
</div>

Hi,

As this is my first project, I really do not have much idea to debug this. I have a listview. I am writing code manually to populate listview. As the listview is very large, I have a search button where user enters a search string. I am trying to build a sql string from here and populate the listview. Everything works fine but when I click on next page, it does not include the search string. I think it is just populating the 2nd page without the search criteria. If I remove the data pager control, it works fine. I am not able to put proper code datapger_PagePropertiesChanging. I appreciate if  someone can help me with this.



Here is my list view markup:
 <div class="topcontent">
                <asp:TextBox ID="txtSearch" runat="server" cssClass="txt"></asp:TextBox>
                <cc1:TextBoxWatermarkExtender ID="tbwatermarkSearch" runat="server" TargetControlID="txtSearch" WatermarkText="Search Contractor..">
                </cc1:TextBoxWatermarkExtender>
                <asp:Button ID="btnSearch" runat="server" cssClass="btn" onClick="btnSearch_Click" Text="Search" />
             </div>
             <asp:ListView ID="lvContractors" runat="server" OnPagePropertiesChanging="lvContractors_PagePropertiesChanging">
               <LayoutTemplate>
                <div class="ListViewGrid">
                    <table class="tblpadding">
                      <tr>
                          <th class="HeaderStyle">
                               Contractor Number
                          </th>
                          <th class="HeaderStyle">
                               First Name
                          </th>
                          <th class="HeaderStyle">
                               Last Name
                          </th>
                          <th class="HeaderStyle">
                               View
                          </th>
                          <th class="HeaderStyle">
                               Edit
                          </th>
                       </tr>
                       <tbody><asp:PlaceHolder runat="server" ID="itemPlaceholder" /></tbody>

                     </table>
                 </div> <!-- End of ListViewGrid -->

                 </LayoutTemplate>
                 <ItemSeparatorTemplate> <td>   <hr /> </td>

                 </ItemSeparatorTemplate>

                  <ItemTemplate>
                    <div >
                        <tr>
                           <td class="RowStyle"><%#Eval("ContractorNumber")%></td>
                           <td class="RowStyle"><%#Eval("FirstName")%></td>
                           <td class="RowStyle"><%#Eval("LastName")%></td>

                           <td class="RowStyle">
                               <asp:HyperLink ID="lnkView" runat="server" CssClass="link"
                                    NavigateUrl='<%# "ContractorEdit.aspx?ID=" + Eval("ContractorNumber") + "&Mode=" + "CV" %>'
                                    Target="_blank" Text="View" />
                           </td>
                           <td class="RowStyle">
                              <asp:HyperLink ID="lnkEdit" runat="server" CssClass="link"
                                    NavigateUrl= '<%# "ContractorEdit.aspx?ID=" + Eval("ContractorNumber") + "&Mode=" + "CE" %>'
                                    Text="Edit"> </asp:HyperLink>

                         </tr>
                      </div>
                   </ItemTemplate>
                   <AlternatingItemTemplate>
                     <div>
                        <tr>
                           <td class="AlternatingRowStyle"><%#Eval("ContractorNumber")%></td>
                           <td class="AlternatingRowStyle"><%#Eval("FirstName")%></td>
                           <td class="AlternatingRowStyle"><%#Eval("LastName")%></td>

                           <td class="AlternatingRowStyle">
                               <asp:HyperLink ID="lnkView" runat="server" CssClass="link"
                                    NavigateUrl='<%# "Contractor.aspx?ID=" + Eval("ContractorNumber")%>'
                                    Target="_blank" Text="View" />
                           </td>
                           <td class="AlternatingRowStyle">
                              <asp:HyperLink ID="lnkEdit" runat="server" CssClass="link"
                                    NavigateUrl= '<%# "ContractorEdit.aspx?ID=" + Eval("ContractorNumber") + "&Mode=" + "CE" %>'
                                    Text="Edit"> </asp:HyperLink>

                         </tr>
                      </div>

                   </AlternatingItemTemplate>

                   <ItemSeparatorTemplate>
                       <tr>
                          <td colspan="5" class="itemseparator"></td>
                      </tr>
                  </ItemSeparatorTemplate>

         </asp:ListView>

         <div class="pager">
            <asp:DataPager PageSize="20" ID="DataPagerContractor" runat="server" PagedControlID="lvContractors"
                            NextPreviousButtonCssClass="PrevNext"
                            CurrentPageLabelCssClass="CurrentPage"
                            NumericButtonCssClass="PageNumber">
                <fields>
                     <asp:NumericPagerField
                          PreviousPageText="&lt; Prev"
                          NextPageText="Next &gt;"
                          ButtonCount="10"
                          NextPreviousButtonCssClass="PrevNext"
                          CurrentPageLabelCssClass="CurrentPage"
                          NumericButtonCssClass="PageNumber" />
                </fields>
            </asp:DataPager>
          </div>
    </div> Code behind this: Partial Class Contractor
    Inherits System.Web.UI.Page

    Private txtKeywordSearchWhereClause As String = ""

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


        If Not Page.IsPostBack Then
            Session("Clicked") = "Contractor"
        End If

        If Not DBNull.Value.Equals(txtKeywordSearchWhereClause) Then
            LoadContractors(txtKeywordSearchWhereClause)
        Else
            LoadContractors("")
        End If

    End Sub

    Private Sub LoadContractors(ByVal strSearch As String)
        Dim strConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("Conn").ConnectionString)

        strConn.Open()

        Dim sql As String = "SELECT * FROM tblContractor1"

        If Not strSearch = "" Then
            sql = sql & strSearch
            sql = sql & " ORDER BY LastName"
        End If


        Dim da As SqlDataAdapter = New SqlDataAdapter(sql, strConn)

        Dim dt As DataTable = New DataTable()

        da.Fill(dt)

        lvContractors.DataSource = dt

        lvContractors.DataBind()
    End Sub



    Protected Sub buttonAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles buttonAdd.Click
        Response.Redirect("ContractorEdit.aspx", False)
    End Sub

    Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
        '   Keyword Search

        Dim txtKeywordSearch As String = txtSearch.Text


        Dim txtWhereClause As String = ""

        If txtKeywordSearch.Trim() <> "" Then
            txtWhereClause = " WHERE FirstName LIKE '%" + txtKeywordSearch + "%'"
            txtWhereClause = txtWhereClause + " OR LastName LIKE '%" + txtKeywordSearch + "%'"
            txtWhereClause = txtWhereClause + " OR ContractorNumber LIKE '%" + txtKeywordSearch + "%'"

            txtKeywordSearchWhereClause = txtWhereClause
        End If

        LoadContractors(txtKeywordSearchWhereClause)

    End Sub

    Protected Sub lvContractors_PagePropertiesChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.PagePropertiesChangingEventArgs) Handles lvContractors.PagePropertiesChanging
        DataPagerContractor.SetPageProperties(e.StartRowIndex, e.MaximumRows, False)
        'rebind List View
        If Not DBNull.Value.Equals(txtKeywordSearchWhereClause) Then
            LoadContractors(txtKeywordSearchWhereClause)
        Else
            LoadContractors("")
        End If
    End Sub
End Class