Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Dim dr As DataRow() Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim sql As String cpath = "P:\HH2003" con.ConnectionString = "Provider=PervasiveOLEDB;Data Source=" & cpath con.Open() sql = "SELECT * FROM Invoices ORDER BY DocumentNumber" da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, "Invoices") con.Close() dr = ds.Tables("Invoices").Select("DocumentNumber = " & (TempInv_no)) If Not (dr Is Nothing) AndAlso dr.Length > 0 Then MessageBox.Show("Found Invoice: " & dr(0)("DocumentNumber").ToString()) frmInvoicing.txtInvoice.SelectAll() frmInvoicing.txtInvoice.Focus() IsinPervasive = True
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|VB/ASP.Net "Value of type 'Date' cannot be converted to 'Integer'"||12||59|
|vb.net Deserialize JSON output - YouTube API (With somewhat of a working example included)||21||75|
|Visual Basic Json to CSV Converter - Converting large json files to csv||2||87|
|Select coumns form Data table?||3||27|
Join the community of 500,000 technology professionals and ask your questions.