jackVB

'add Microsoft DAO 3.5 in the project from Reference Dim myDb as Database Dim mySet as Recordset 'write in Form Load event Set myDB=Open Database("Path of the .mdb") Set Myset=myDb.Open Recordset("TableName",dbopendynaset) ' if you want to display in some text box TextBox1.text=mySet.Field(0) TextBox2.Text=mySet.Field(1) ' and so on. Eidt mySet.Edit myset(0)=TextBox1.Text …

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