jackVB

I use a database connection string as below and my program work fine. Public Function initdb() Set ws = DBEngine.Workspaces(0) Set db = ws.OpenDatabase(App.Path & "\Masterfile.mdb") Set rs = db.OpenRecordset("Detail", dbOpenTable) max = rs.RecordCount Exit Function End Function *********************************** But now I lock the msaccess table ie. Masterfile.mdb with password …

Hello Frens, I tried to update change made in database shown DataGridView1 of Visual Studio 2008 with the following codes. But an error message comes as "Object reference not set to an instance of an object". Public Class Form1 Dim cmd As Odbc.OdbcCommand Dim adp As Odbc.OdbcDataAdapter Private Sub Form1_Load(ByVal …

I want to update data using DataGridView in Visual Studio2008 with the following code. But it is not working. Plz help me. Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click cmd = New Odbc.OdbcCommand("UPDATE Table1 SET Name") Me.Table1TableAdapter.Update(DataSet1.Table1) MsgBox("Updated") End Sub

Hello, Can anyone please give me the coding to caculate BODMAS of the data shown in the FlexGrid or a database. The calculation is not to be saved in the database back. It is for the use of the client. Thanks

Hello everyone. Happy New Year. correct coding for connectivity of oracle database with VB 6 or VB.Net Thanks