.NET (Core and Framework)

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.

michael_jhons wrote:

the controls of the presentation layer should be loaded and customized via an XML file