Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
'in my webpage codebehind strSQL = "SELECT * FROM([CTC Table])" Dim objCC As New CreateConnection(strConnection, strSQL) objCC.CreateDataView("Ref No") 'Does not work properly objCC.cnnADO.Close() 'connection works fine but dt.Load(cmd.ExecuteReader()) does not Public Class CreateConnection Public ds As New DataSet() Public cnnADO As OleDbConnection Public cmd As OleDbCommand Public dt As DataTable Public Sub New(ByVal strConnection As String, ByVal strSQL As String) Connect(strConnection, strSQL) End Sub Private Sub Connect(ByVal strConnection As String, ByVal strSQL As String) cnnADO = New OleDbConnection(strConnection) cmd = New OleDbCommand(strConnection, cnnADO) cmd.CommandText = strSQL cnnADO.Open() Dim da As New OleDbDataAdapter(strSQL, strConnection) da.Fill(ds) End Sub Public Sub CreateDataView(ByVal strColumn) dt = New DataTable() dt = ds.Tables("CTC Table") dt.Load(cmd.ExecuteReader()) Dim dv As DataView = New DataView(dt) 'dv.RowFilter = "" dv.Sort = strColumn End Sub End Class
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.