The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
'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
|deduplicating based on criteria||2||21|
|How to make the value of the control text to zero if the user presses the Delete key (in Access 2016).||11||33|
|Access subform not displaying on tab in naviation form||5||21|
|I have a GridView and I want to hide the first field in the Grid. However, I want to retrieve the value from this hidden field. Do you know how I would do so using CSS?||1||17|