Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.
'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
|help with issues with ReportViewer in VS2015||5||22|
|How to Get total minutes between two hours||4||26|
|Access db, trying to list the results of query (in a recordset) in a list box using VBA||4||17|
|In C#, how would you convert a byte array to its integer value equivalent?||12||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!