1 Replies - 204 Views - Last Post: 21 October 2019 - 02:40 PM Rate Topic: -----

#1 shemmy   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 21-October 19

Updates not showing in database

Posted 21 October 2019 - 02:30 PM

I am trying to update a typed database directly from the datagridview. Everything works fine, I even added a text box for verification , however when I reload the table again the changes are gone.
 
    Public Class Form1

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        AdaCountries.Fill(Area.Countries)
        DgView1.DataSource = Area.Countries
    End Sub
    Private Sub DgView1_CellValueChanged(sender As Object, e As DataGridViewCellEventArgs) Handles DgView1.CellValueChanged
        If DgView1.CurrentCell.OwningColumn.Name = CoMakom Then
            Dim CnRow As DSStamps.CountriesRow = DirectCast(DgView1.Rows(e.RowIndex).DataBoundItem, DataRowView).Row
            TextBox1.Text = CnRow.Makom
            Try
                AdaCountries.Update(CnRow)
            Catch ex As Exception
                MsgBox(ex.Message)
            End Try

        End If
    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Area.Countries.Rows.Clear()
        AdaCountries.Fill(Area.Countries)
    End Sub
End Class


This post has been edited by modi123_1: 21 October 2019 - 02:37 PM


Is This A Good Question/Topic? 0
  • +

Replies To: Updates not showing in database

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15356
  • View blog
  • Posts: 61,566
  • Joined: 12-June 08

Re: Updates not showing in database

Posted 21 October 2019 - 02:40 PM

What is 'AdaCountries'?

Make sure you are ending the edit, and have all the 'update' needed information complete.

Personally I avoid all that nonsense and just deal with the dataset and some objects.

https://www.dreaminc...-adapter-setup/
https://www.dreaminc...-command-setup/
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1