Imports System.Data Imports System.Data.SqlClient Imports Ajax Partial Class UserControl_BrandSearch Inherits System.Web.UI.UserControl Shared flag As Boolean Shared btn As LinkButton Shared chkflag As Boolean Shared jds As New DataSet Shared jdt As New DataTable Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Try If Request.QueryString("brandpage") = Nothing And Request.QueryString("bsid") = Nothing Then Session("brandpage") = 1 'loadcategory() getsortBrand("All") ElseIf Request.QueryString("brandpage") = Nothing Then Session("brandpage") = 1 getsortBrand(Request.QueryString("bsid").ToString) ElseIf Request.QueryString("bsid") = Nothing Then Session("brandpage") = Request.QueryString("brandpage") 'Session("ProdTable") = Nothing loadcategory() Else Session("brandpage") = Request.QueryString("brandpage") 'If IsNothing(Session("ProdTable")) Then getsortBrand(Request.QueryString("bsid").ToString) 'End If loadcategory() End If 'Panel1.Style.Add("visibility", "hidden") Catch ex As Exception Response.Write(ex.Message.ToString) End Try End If End Sub Private Sub loadcategory() Try If IsNothing(Session("BrandTable")) Then Dim dt As New DataTable Dim ds As New DataSet Dim con As New SqlConnection con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("ConnectionString") Dim Str As String 'Str = "SELECT DISTINCT LOWER(SUBSTRING(LTRIM(Product_Master.Product_Name), 1, 28)) AS SProduct_Name, Row_Number() over (order by RTrim(LTrim(Product_Name))) as PIndex, LOWER(REPLACE(LTRIM(RTRIM(Product_Master.Product_Name)), ' ', '-')) AS Product_Name, LOWER(REPLACE(REPLACE(REPLACE(Category_Master.Category_Name, ' ', '-'), ',', ''), '&-', '')) AS Category_name FROM Product_Master LEFT OUTER JOIN Category_Master ON Product_Master.Product_CategoryId = Category_Master.Category_Kid WHERE (Product_Master.Product_Approved = 'Y') AND (Product_Master.Product_IsDeleted = '0') AND (Category_Master.Category_IsDeleted = '0') " 'Str = "Select Brand_Distinct.*, Row_Number() over (order by RTrim(LTrim(Brand_Name))) as BIndex from Brand_Distinct" Str = "Select Brand_Distinct.* from Brand_Distinct order by Brand_Name" ' Str = "select distinct lower(substring(LTrim(Product_Name),1,28)) as SProduct_Name,LTrim(Product_Name) as Product_Name from Product_Master where Product_Approved='Y' and Product_Isdeleted='0' order by product_name asc" If con.State = Data.ConnectionState.Open Then con.Close() End If da = New SqlDataAdapter(Str, con) da.Fill(ds, "Brand") dt = ds.Tables("Brand") Session("BrandTable") = dt End If 'End If Dim dt1 As DataTable dt1 = CType(Session("BrandTable"), DataTable).DefaultView.ToTable Dim dt2 As DataTable dt2 = CType(Session("BrandTable"), DataTable) If Request.QueryString("brandpage") = Nothing And Request.QueryString("bsid") = Nothing Then dt1 = CType(Session("BrandTable"), DataTable) End If If Request.QueryString("bsid") = Nothing Then dt1 = CType(Session("BrandTable"), DataTable) Else dt1 = CType(Session("BrandTable"), DataTable).DefaultView.ToTable End If 'If Request.QueryString.Count = 0 Then ' dt1 = CType(Session("BrandTable"), DataTable) 'Else ' If Request.QueryString("brandpage") <> Nothing Then ' If Request.QueryString("bsid") = Nothing Then ' dt1 = CType(Session("BrandTable"), DataTable) ' Else ' dt1 = CType(Session("BrandTable"), DataTable).DefaultView.ToTable ' End If ' Else ' dt1 = CType(Session("BrandTable"), DataTable).DefaultView.ToTable ' End If 'End If If Request.QueryString("brandpage") <> Nothing Then Dim dtCat As New DataTable dtCat = dt1.Clone '''Dim start As Integer '''start = CType(dt.Rows(0).Item("Pindex").ToString(), Integer) Dim currentstart As Integer Dim currentend As Integer currentstart = ((CType(Request.QueryString("brandpage"), Integer) - 1) * 17) currentend = currentstart + 18 While currentstart <> currentend Try dtCat.Rows.Add(dt1.Rows(currentstart).ItemArray) currentstart = currentstart + 1 Catch ex As Exception currentstart = currentend End Try End While gvbrandsearch.Columns(1).Visible = True gvbrandsearch.DataSource = dtCat.DefaultView.ToTable 'ds.Tables("Product_Mast") gvbrandsearch.DataBind() gvbrandsearch.Columns(1).Visible = False If gvbrandsearch.Rows.Count < 17 Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).Visible = False Else CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).Visible = True End If If Session("brandpage") = "1" Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = False CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) + 1) Else Session("brandpage") = Request.QueryString("brandpage").ToString() CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = True CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) - 1) CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) + 1) End If If Request.QueryString("bsid") <> Nothing Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & Request.QueryString("bsid") & "&brandpage=" & CType(Session("brandpage"), Integer) - 1) CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & Request.QueryString("bsid") & "&brandpage=" & CType(Session("brandpage"), Integer) + 1) End If Exit Sub End If 'End If gvbrandsearch.Columns(1).Visible = True gvbrandsearch.DataSource = Nothing gvbrandsearch.DataSource = dt1.DefaultView.ToTable gvbrandsearch.DataBind() gvbrandsearch.Columns(1).Visible = False If gvbrandsearch.Rows.Count < 17 Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).Visible = False Else CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).Visible = True End If If Session("brandpage") = "1" Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = False CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) + 1) Else Session("brandpage") = Request.QueryString("brandpage").ToString() CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = True CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) - 1) CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?brandpage=" & CType(Session("brandpage"), Integer) + 1) End If If Request.QueryString("bsid") <> Nothing Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & Request.QueryString("bsid") & "&brandpage=" & CType(Session("brandpage"), Integer) - 1) CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & Request.QueryString("bsid") & "&brandpage=" & CType(Session("brandpage"), Integer) + 1) End If Catch ex As Exception Response.Write(ex.Message.ToString) End Try End Sub ' _ 'Public Function JBrand(ByVal BrandID As String) As DataTable ' PBDT.DefaultView.RowFilter = "Brand_KId ='" & BrandID & "'" ' 'PBDT.AcceptChanges() ' Dim dt As DataTable = PBDT.DefaultView.ToTable ' Return dt 'End Function Protected Sub gvbrandsearch_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gvbrandsearch.PageIndexChanging Try If Session("brandid") = Nothing Then gvbrandsearch.PageIndex = e.NewPageIndex loadcategory() chkflag = True ElseIf Session("brandid") <> Nothing Then gvbrandsearch.PageIndex = e.NewPageIndex getsortBrand(Session("brandid")) Else End If Catch ex As Exception Response.Write(ex.Message.ToString) End Try End Sub Protected Sub getsortBrand(ByRef qstr As String) Try Dim str As String = "" If IsNothing(Session("BrandTable")) Then Dim dt As New DataTable Dim ds As New DataSet Dim con As New SqlConnection con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("ConnectionString") Dim Str1 As String 'Str = "SELECT DISTINCT LOWER(SUBSTRING(LTRIM(Product_Master.Product_Name), 1, 28)) AS SProduct_Name, Row_Number() over (order by RTrim(LTrim(Product_Name))) as PIndex, LOWER(REPLACE(LTRIM(RTRIM(Product_Master.Product_Name)), ' ', '-')) AS Product_Name, LOWER(REPLACE(REPLACE(REPLACE(Category_Master.Category_Name, ' ', '-'), ',', ''), '&-', '')) AS Category_name FROM Product_Master LEFT OUTER JOIN Category_Master ON Product_Master.Product_CategoryId = Category_Master.Category_Kid WHERE (Product_Master.Product_Approved = 'Y') AND (Product_Master.Product_IsDeleted = '0') AND (Category_Master.Category_IsDeleted = '0') " 'Str1 = "Select Brand_Distinct.*, Row_Number() over (order by RTrim(LTrim(Brand_Name))) as BIndex from Brand_Distinct" Str1 = "Select Brand_Distinct.* from Brand_Distinct order by Brand_Name" ' Str = "select distinct lower(substring(LTrim(Product_Name),1,28)) as SProduct_Name,LTrim(Product_Name) as Product_Name from Product_Master where Product_Approved='Y' and Product_Isdeleted='0' order by product_name asc" If con.State = Data.ConnectionState.Open Then con.Close() End If da = New SqlDataAdapter(Str1, con) da.Fill(ds, "Brand") dt = ds.Tables("Brand") Session("BrandTable") = dt End If Select Case qstr.ToString Case "All" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'A%' or Brand_Name LIKE 'B%' or Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "A" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'A%' or Brand_Name LIKE 'B%' or Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%'or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'A%' or Brand_Name LIKE 'B%' or Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "B" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'B%' or Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'B%' or Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "C" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'C%' or Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "D" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'D%' or Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "E" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'E%' or Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "F" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'F%' or Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "G" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'G%' or Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "H" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'H%' or Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "I" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'I%' or Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "J" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'J%' or Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "K" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'K%' or Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "L" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'L%' or Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "M" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'M%' or Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "N" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'N%' or Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "O" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'O%' or Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "P" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'P%' or Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "Q" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'Q%' or Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "R" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'R%' or Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "S" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'S%' or Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "T" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'T%' or Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "U" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'U%' or Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "V" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'V%' or Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "W" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'W%' or Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "X" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'X%' or Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "Y" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'Y%' or Brand_Name LIKE 'Z%' order by Brand_Name asc " Case "Z" CType(Session("BrandTable"), DataTable).DefaultView.RowFilter = "Brand_Name LIKE 'Z%'" 'str = "SELECT distinct Brand_kid,Brand_Name FROM Brand_Master WHERE Brand_IsDeleted = '0' AND Brand_Name LIKE 'Z%' order by Brand_Name asc " End Select gvbrandsearch.Columns(1).Visible = True gvbrandsearch.DataSource = CType(Session("BrandTable"), DataTable).DefaultView.ToTable gvbrandsearch.DataBind() gvbrandsearch.Columns(1).Visible = False If CType(Session("BrandTable"), DataTable).DefaultView.ToTable.Rows.Count < 17 Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).Visible = False End If If Session("brandpage") = "1" Then CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = False CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & qstr & "&brandpage=" & CType(Session("brandpage"), Integer) + 1) Else Session("brandpage") = Request.QueryString("brandpage").ToString() CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).Visible = True CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlBack"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & qstr & "&brandpage=" & CType(Session("brandpage"), Integer) - 1) CType(gvbrandsearch.FooterRow.Cells(0).FindControl("hrlNext"), HyperLink).NavigateUrl = ResolveUrl("~/home.aspx?bsid=" & qstr & "&brandpage=" & CType(Session("brandpage"), Integer) + 1) End If Catch ex As Exception Response.Write("Brand" & ex.Message.ToString) End Try End Sub Protected Sub gvbrandsearch_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvbrandsearch.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then CType(e.Row.Cells(0).FindControl("LinkButton1"), HyperLink).Text = StrConv(CType(e.Row.Cells(0).FindControl("LinkButton1"), HyperLink).Text, VbStrConv.ProperCase) End If End Sub End Class