Reply

Re: Merge Cell in GridView

Jun 01, 2009 08:54 AM|LINK

I do not define the columns or rows that will be spanned within the gridview template.

I add those cells and set their rowspan or colspan values during the gridview's rowcreated event during data binding.

ASP.NET RowSpan in GridView using RowCreated Event

T-SQL programming SQL Server Tutorials
SQL Server 2012

Reply

Re: Merge Cell in GridView

Jun 01, 2009 11:17 AM|LINK

nice post

Read my blog | Twitter
Please click "mark as answer" if this post helped you.

Reply

Re: Merge Cell in GridView

May 06, 2010 08:38 PM|LINK

When i tried implementing ur example :

I m getting the error as :

Server Error in '/WebSite1' Application.

Specified argument was out of the range of valid values.
Parameter name: index

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: index

Source Error:

Line 147:        For Each gvr As GridViewRow In dgPaging.Rows

Line 148:            If gvr.RowType = DataControlRowType.DataRow Then
Line 149:                If gvr.Cells(0).Text = text Then
Line 150:                    count += 1
Line 151:                Else

Source File: C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\SearchHS1.aspx Line: 149

Stack Trace:

[ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: index]
   System.Web.UI.ControlCollection.get_Item(Int32 index) +8668910
   System.Web.UI.WebControls.TableCellCollection.get_Item(Int32 index) +27
   ASP.searchhs1_aspx.dgPaging_ItemDataBound(Object sender, GridViewRowEventArgs e) in C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\SearchHS1.aspx:149
   System.Web.UI.WebControls.GridView.OnRowDataBound(GridViewRowEventArgs e) +108
   System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) +167
   System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +2417
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57
   System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) +14
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +31
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   System.Web.UI.WebControls.GridView.DataBind() +4
   ASP.searchhs1_aspx.btnSearch_OnClick(Object sender, EventArgs e) in C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\SearchHS1.aspx:207
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version

My Code is As Follows :

<div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><%@ Page Language="VB" Debug="true"%></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><%@ Import Namespace="System.Data" %></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><%@ Import Namespace="System.Data.OleDb" %></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><script language="VB" runat="server"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Public Property CurrentPage() As Integer</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Get</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' look for current page in ViewState</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim o As Object = Me.ViewState("_CurrentPage")</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' If o Is Nothing Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Return 0</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Else</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' default to showing the first page</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Return CInt(o)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Get</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Set(ByVal value As Integer)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Me.ViewState("_CurrentPage") = value</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Set</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Property</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Private Sub cmdPrev_Click(ByVal sender As Object, ByVal e As EventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' Set viewstate variable to the previous page</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' CurrentPage -= 1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' Reload control</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' btnSearch_OnClick(sender, e)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Private Sub cmdNext_Click(ByVal sender As Object, ByVal e As EventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' Set viewstate variable to the next page</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' CurrentPage += 1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' Reload control</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' btnSearch_OnClick(sender, e)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> 'Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim objCommand As OleDbCommand</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim objAdapter As OleDbDataAdapter</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim objDataSet As DataSet</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim strSearch6 As String</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim buffer As StringBuilder</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' buffer = New StringBuilder()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' 'Dim objReader As OleDbDataReader</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\App_Data\project2.mdb"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim strSQLQuery As String</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' strSearch6 = txtSearch6.Text</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' If (Len(Trim(strSearch6))) > 0 Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' strSQLQuery = "SELECT [filename],[AKA/HS1] FROM [Primary] WHERE [AKA/HS1] LIKE '%" & Replace(strSearch6, "'", "''") & "%'ORDER BY [filename];"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim cn As New OleDbConnection(objConnection)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' cn.Open()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objCommand = New OleDbCommand(strSQLQuery, cn)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' 'objReader = objCommand2.ExecuteReader()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' 'While (objReader.Read())</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' str = ""</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' ' str = str + DirectCast(objReader(0), String)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' 'End While</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objAdapter = New OleDbDataAdapter(objCommand)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objDataSet = New DataSet()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objAdapter.Fill(objDataSet)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Dim objPds As New PagedDataSource()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objPds.DataSource = objDataSet.Tables(0).DefaultView</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objPds.AllowPaging = True</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objPds.PageSize = 88</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' objPds.CurrentPageIndex = CurrentPage</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' cmdPrev.Enabled = Not objPds.IsFirstPage</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' cmdNext.Enabled = Not objPds.IsLastPage</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.DataSource = objPds</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.DataBind()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.RepeatDirection = RepeatDirection.Vertical</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.RepeatLayout = RepeatLayout.Table</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.RepeatColumns = 8</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.BorderWidth = Unit.Pixel(1)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' DataList1.GridLines = GridLines.Both</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' holder.Visible = True</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' cn.Close()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' Else</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' txtSearch6.Text = "Add the text here!!"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' End Sub </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Private Function ConvertSortDirectionToSql(ByVal sortDirection__1 As SortDirection) As String</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim newSortDirection As String = [String].Empty</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Select Case sortDirection__1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Case SortDirection.Ascending</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> newSortDirection = "ASC"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Exit Select</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Case SortDirection.Descending</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> newSortDirection = "DESC"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Exit Select</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Select</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Return newSortDirection</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Function</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Protected Sub gridView_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> btnSearch_OnClick(sender, e)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.PageIndex = e.NewPageIndex</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataBind()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Protected Sub gridView_Sorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim dataTable As DataTable = TryCast(dgPaging.DataSource, DataTable)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If dataTable IsNot Nothing Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim dataView As New DataView(dataTable)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dataView.Sort = (e.SortExpression & " ") + ConvertSortDirectionToSql(e.SortDirection)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataSource = dataView</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataBind()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim previousCat As String = ""</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Protected Sub dgPaging_ItemDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim text As String = ""</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim count As Integer = 0</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim ht As New Hashtable()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' loop through all rows to get row counts</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> For Each gvr As GridViewRow In dgPaging.Rows</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If gvr.RowType = DataControlRowType.DataRow Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If gvr.Cells(0).Text = text Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> count += 1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Else</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If count > 0 Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ht.Add(text, count)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> text = gvr.Cells(0).Text</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> count = 1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Next</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If count > 1 Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ht.Add(text, count)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ' loop through all rows again to set rowspan</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> text = ""</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> For Each gvr As GridViewRow In dgPaging.Rows</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If gvr.RowType = DataControlRowType.DataRow Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If gvr.Cells(0).Text = text Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> gvr.Cells.Remove(gvr.Cells(0))</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Else</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> text = gvr.Cells(0).Text</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> gvr.Cells(0).RowSpan = Convert.ToInt32(ht(text))</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Next</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objCommand As OleDbCommand</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objAdapter As OleDbDataAdapter</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objDataSet As DataTable</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch6 As String</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\My Documents\Downloads\MergeCellsExample\MergeCellsExample\App_Data\project2.mdb"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim cn As New OleDbConnection(objConnection)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSQLQuery As String</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch6 = txtSearch6.Text</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If (Len(Trim(strSearch6))) > 0 Then</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSQLQuery = "SELECT [AKA/HS1],[filename],[image] FROM [Primary] WHERE [AKA/HS1] LIKE '%" & Replace(strSearch6, "'", "''") & "%'ORDER BY [filename];"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> cn.Open()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim cmd As New OleDbCommand(strSQLQuery, cn)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objCommand = New OleDbCommand(strSQLQuery, cn)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objAdapter = New OleDbDataAdapter(objCommand)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objDataSet = New DataTable()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objAdapter.Fill(objDataSet)</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataSource = objDataSet</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataBind()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> cn.Close()</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Else</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> txtSearch6.Text = "Add the text here!!"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Sub</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></script></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><html></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><head></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><title>SunFlower</title></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <link href="style.css" rel="stylesheet" type="text/css" media="screen" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></head></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><body id="p2"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="wrapper"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="header"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i1"><a href="#" >About</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i2"><a href="SearchHS1.aspx">Holcomb</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i3"><a href="SearchHS2.aspx">Garden City</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i4"><a href="SearchHS3.aspx">Ft. Dodge</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i5"><a href="SearchHS4.aspx">Great Bend</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i6"><a href="SearchHS5.aspx">Cimarron River</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li id="i7"><a href="SearchHS6.aspx">Clifton</a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Index</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="#">Files</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="page"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="page-bgtop"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="page-bgbtm"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="content"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <form id="Form1" runat="server"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <table></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><td><h2> HOLCOMB STATION </h2></td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><td></td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><td></td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></table></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><table></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Label ID="Label6" runat="server" style="color: #000000" Text="AKA/HS1:"></asp:Label></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:TextBox ID="txtSearch6" runat="server" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <td align="center"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_OnClick" </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Text="Search" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </table></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <%--<asp:DataList id="DataList1" runat="server"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> BorderColor="Black"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> CellPadding="3"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Font-Names="Verdana"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Font-Size="10pt"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> HeaderStyle-BackColor="#ffffff" BackColor="#ffffff" GridLines="Both"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <HeaderTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> HS1</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </HeaderTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><HeaderStyle BackColor="#000000"></HeaderStyle></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <%#Eval("filename")%></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <%#Eval("AKA/HS1")%> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </asp:DataList>--%></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:GridView ID="dgPaging" Runat="server" AllowPaging="True" </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> AllowSorting="True" AutoGenerateColumns="False" </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> EmptyDataText="There are no data records to display." </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> OnPageIndexChanging="gridView_PageIndexChanging" OnSorting="gridView_Sorting" </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> PageSize="15" HorizontalAlign="Justify" OnRowDataBound="dgPaging_ItemDataBound"</div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> ></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <AlternatingRowStyle HorizontalAlign="Justify" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <EmptyDataRowStyle BackColor="White" ForeColor="Black" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <Columns></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:TemplateField></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <img src="image/<%# Eval("image") %>" width="400px"/></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </asp:TemplateField></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:TemplateField HeaderText="HS1"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <a href='pdf/<%# Eval("filename") %>#nameddest=HS1-<%# Eval("AKA/HS1")%> '>HS1-<%#Eval("AKA/HS1")%> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </a></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ItemTemplate></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </asp:TemplateField></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></Columns></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></asp:GridView></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><%--<table></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <td> <asp:PlaceHolder ID="holder" runat="server" Visible="false"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:button id="cmdPrev" runat="server" text=" << " onclick="cmdPrev_Click"></asp:button></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:button id="cmdNext" runat="server" text=" >> " onclick="cmdNext_Click"></asp:button></asp:PlaceHolder></td></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </tr></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </table> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> --%></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </form></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div style="clear: both;"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="sidebar"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <h2>Features</h2></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchHS1.aspx">Search By HS1#</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchKeyword.aspx">Search By Keywords</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchSDR.aspx">Search By SDR#</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchVendName.aspx">Search by Vendor Name</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchDrawing.aspx">Search by VEND/MFG Drawing</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchMFG.aspx">Search by MFG Code</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <li><a href="SearchCombination.aspx">Search by Combination</a></li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <img src="images/power.bmp" width="200px" /></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </li></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </ul></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div style="clear: both;"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <div id="footer"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <p>Copyright (c)2010 Powermatics Consultants All Rights Reserved.</p></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></body></div> <div style="position: absolute; left: -10000px; top: 770px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></html></div> <div></div>

<%@ Page Language="VB" Debug="true"%>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.OleDb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

' Public Property CurrentPage() As Integer

' Get

' ' look for current page in ViewState

' Dim o As Object = Me.ViewState("_CurrentPage")

' If o Is Nothing Then

' Return 0

' Else

' ' default to showing the first page

' Return CInt(o)

' End If

' End Get

' Set(ByVal value As Integer)

' Me.ViewState("_CurrentPage") = value

' End Set

' End Property

' Private Sub cmdPrev_Click(ByVal sender As Object, ByVal e As EventArgs)

' ' Set viewstate variable to the previous page

' CurrentPage -= 1

' ' Reload control

' btnSearch_OnClick(sender, e)

' End Sub

' Private Sub cmdNext_Click(ByVal sender As Object, ByVal e As EventArgs)

' ' Set viewstate variable to the next page

' CurrentPage += 1

' ' Reload control

' btnSearch_OnClick(sender, e)

' End Sub

'Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)

' Dim objCommand As OleDbCommand

' Dim objAdapter As OleDbDataAdapter

' Dim objDataSet As DataSet

' Dim strSearch6 As String

' Dim buffer As StringBuilder

' buffer = New StringBuilder()

' 'Dim objReader As OleDbDataReader

' Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\App_Data\project2.mdb"

' Dim strSQLQuery As String

' strSearch6 = txtSearch6.Text

' If (Len(Trim(strSearch6))) > 0 Then

' strSQLQuery = "SELECT [filename],[AKA/HS1] FROM [Primary] WHERE [AKA/HS1] LIKE '%" & Replace(strSearch6, "'", "''") & "%'ORDER BY [filename];"

' Dim cn As New OleDbConnection(objConnection)

' cn.Open()

' objCommand = New OleDbCommand(strSQLQuery, cn)

' 'objReader = objCommand2.ExecuteReader()

' 'While (objReader.Read())

' ' str = ""

' ' str = str + DirectCast(objReader(0), String)

' 'End While

' objAdapter = New OleDbDataAdapter(objCommand)

' objDataSet = New DataSet()

' objAdapter.Fill(objDataSet)

' Dim objPds As New PagedDataSource()

' objPds.DataSource = objDataSet.Tables(0).DefaultView

' objPds.AllowPaging = True

' objPds.PageSize = 88

' objPds.CurrentPageIndex = CurrentPage

' cmdPrev.Enabled = Not objPds.IsFirstPage

' cmdNext.Enabled = Not objPds.IsLastPage

' DataList1.DataSource = objPds

' DataList1.DataBind()

' DataList1.RepeatDirection = RepeatDirection.Vertical

' DataList1.RepeatLayout = RepeatLayout.Table

' DataList1.RepeatColumns = 8

' DataList1.BorderWidth = Unit.Pixel(1)

' DataList1.GridLines = GridLines.Both

' holder.Visible = True

' cn.Close()

' Else

' txtSearch6.Text = "Add the text here!!"

' End If

' End Sub

Private Function ConvertSortDirectionToSql(ByVal sortDirection__1 As SortDirection) As String

Dim newSortDirection As String = [String].Empty

Select Case sortDirection__1

Case SortDirection.Ascending

newSortDirection = "ASC"

Exit Select

Case SortDirection.Descending

newSortDirection = "DESC"

Exit Select

End Select

Return newSortDirection

End Function

Protected Sub gridView_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)

btnSearch_OnClick(sender, e)

dgPaging.PageIndex = e.NewPageIndex

dgPaging.DataBind()

End Sub

Protected Sub gridView_Sorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs)

Dim dataTable As DataTable = TryCast(dgPaging.DataSource, DataTable)

If dataTable IsNot Nothing Then

Dim dataView As New DataView(dataTable)

dataView.Sort = (e.SortExpression & " ") + ConvertSortDirectionToSql(e.SortDirection)

dgPaging.DataSource = dataView

dgPaging.DataBind()

End If

End Sub

Dim previousCat As String = ""

Protected Sub dgPaging_ItemDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

Dim text As String = ""

Dim count As Integer = 0

Dim ht As New Hashtable()

' loop through all rows to get row counts

For Each gvr As GridViewRow In dgPaging.Rows

If gvr.RowType = DataControlRowType.DataRow Then

If gvr.Cells(0).Text = text Then

count += 1

Else

If count > 0 Then

ht.Add(text, count)

End If

text = gvr.Cells(0).Text

count = 1

End If

ht.Add(text, count)

End If

' loop through all rows again to set rowspan

text = ""

For Each gvr As GridViewRow In dgPaging.Rows

If gvr.RowType = DataControlRowType.DataRow Then

If gvr.Cells(0).Text = text Then

gvr.Cells.Remove(gvr.Cells(0))

Else

text = gvr.Cells(0).Text

gvr.Cells(0).RowSpan = Convert.ToInt32(ht(text))

End If

Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)

Dim objCommand As OleDbCommand

Dim objAdapter As OleDbDataAdapter

Dim objDataSet As DataTable

Dim strSearch6 As String

Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\My Documents\Downloads\MergeCellsExample\MergeCellsExample\App_Data\project2.mdb"

Dim cn As New OleDbConnection(objConnection)

Dim strSQLQuery As String

strSearch6 = txtSearch6.Text

If (Len(Trim(strSearch6))) > 0 Then

strSQLQuery = "SELECT [AKA/HS1],[filename],[image] FROM [Primary] WHERE [AKA/HS1] LIKE '%" & Replace(strSearch6, "'", "''") & "%'ORDER BY [filename];"

cn.Open()

Dim cmd As New OleDbCommand(strSQLQuery, cn)

objCommand = New OleDbCommand(strSQLQuery, cn)

objAdapter = New OleDbDataAdapter(objCommand)

objDataSet = New DataTable()

objAdapter.Fill(objDataSet)

dgPaging.DataSource = objDataSet

dgPaging.DataBind()

cn.Close()

Else

txtSearch6.Text = "Add the text here!!"

End If

End Sub

</script>

<html>

<head>

<title>SunFlower</title>

</head>

</div>

<ul>

<li id="i1"><a href="#" >About</a></li>

<li id="i2"><a href="SearchHS1.aspx">Holcomb</a>

<ul>