What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Public Shared Function GetQuery () As String GetQueryFromCms = "" Dim Idcat As String = HttpContext.Current.Request.QueryString("IdCat") Dim IdSubcat As String = HttpContext.Current.Request.QueryString("IdSubCat") Dim SqlTable As String = HttpContext.Current.Request.QueryString("Tb") Dim SqlStr As String = "" Dim Search As String = HttpContext.Current.Request.QueryString("Search") Dim SqlC As String = "" '----- SqlStr = "Select * from " & SqlTable & " where " & SqlCat & SqlC & " order by id desc" GetQueryFromCms = SqlStr End Function
Public Shared Function GetGrid(ByVal xGrid As GridView, ByVal xSqlString As String) As GridView Dim conn As SqlConnection = DB.DbInitConn() Dim dataset As New DataSet Dim adapter As SqlDataAdapter Try adapter = New SqlDataAdapter(xSqlString, conn) adapter.Fill(dataset, "table") xGrid.DataSource = dataset '---------------- xGrid.DataBind() Catch err As Exception GnErrorMessage("GetGridView()", ErrorToString().ToString) Finally conn.Close() End Try Return xGrid End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.