.NET (Core and Framework)

Dim con As New OleDb.OleDbConnection
Dim inc As Integer
Dim MaxRows As Integer
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
Dim dt As DataTable



Private Sub Sampler_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

ds = new DataSet("dataSet");
dt = new DataTable("Contacts");
ds.Tables.Add(dt);
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
"Data Source = c:\Sadsign.mdb"
con.Open()

sql = "SELECT * FROM Names"
da = New OleDb.OleDbDataAdapter(sql, con)


da.Fill(dt, "contacts")
'con.Close()
'MaxRows = ds.Tables("contacts").Rows.Count
'inc = -1

End Sub

Private Sub Sampler_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

      ds = New DataSet("dataSet")
      dt = New DataTable()
      ds.Tables.Add(dt)
      con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
      "Data Source = c:\Sadsign.mdb"
      con.Open()

      sql = "SELECT * FROM [Names]"
      da = New OleDb.OleDbDataAdapter(sql, con)

      da.Fill(dt)
      'con.Close()
      'MaxRows = ds.Tables("contacts").Rows.Count
      'inc = -1

  End Sub

da = New OleDb.OleDbDataAdapter(sql, con)
        cb = New OleDb.OleDbCommandBuilder(da)
        Dim newRow As DataRow
        newRow = ds.Tables("employeeTable").NewRow
        ds.Tables("employeeTable").Rows.Add(newRow)
        newRow.Item("Position") = comboPosition.Text
        newRow.Item("Last_Name") = txtLastName.Text
        newRow.Item("First_Name") = txtFirstName.Text


        da.Update(ds, "employeeTable")

dfan23 wrote:

Now I know that Name/Names are not valid as variable names.

dfan23 wrote:

If would you mine sir I would like to ask how to add a new row
to my database then how to update the changes made into the database.
I have a code for adding a new row but still got error in updating it.

fdmaxey wrote:

I must say, this forum used to have people who actually tried to help. Your petty sarcasm is both uncalled for and counter-productive. If you are incapable of offering anything positive, please don't answer at all.

Prabhanand Nagarajan wrote:

I need my .net application written in vb.net to communicate to or process a application that runs on a mainframe system.