Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
connecting to access via VB.NET
Name: shelly121 Date: February 21, 2005 at 03:43:59 Pacific OS: - CPU/Ram: -
Comment:
plz help!!im tryn to connect my mortgage application in vb.net to my database in access. I have added the data adapter using the wizard,which adds the connection too. and this is my code on the code page: BUT IT DOESNT RECOGNISE "ADODB CONNECTION():-IT SAYS ITS NOT DEFINED?? "Imports System.IO Public Class frmClients Inherits System.Windows.Forms.Form Dim CN As New ADODB.Connection() Dim RS As New ADODB.Recordset()
#Region " Windows Form Designer generated code "
Public Sub New() MyBase.New()
'This call is required by the Windows Form Designer. InitializeComponent()
'Add any initialization after the InitializeComponent() call
Summary: You seem to be mixing vb.net syntax with SQL syntax, Try strSQL = " DELETE FROM tblProducts WHERE prodID = '' " and strSQL = " DELETE FROM tblProducts WHERE prodID is null " ...
Summary: Hello...I have been trying to learn about vb.net by doing online tutorials, but I'm having problems. I started a project with vb that accesses an access db. I can click around to see all of the recor...