Pozdrav.
Radim na win aplikaciji (vb.net, mysql)
Imam pitanje. Na jednoj formi prikazujem podatke u datagrid-u, svi podaci su iz jedne tabele.
Kako da odradim update svih izmena koje se naprave u datagrid-u
Kod na load-ovanju strane je
Code:
Dim conn = New MySqlConnection
conn.ConnectionString = "database=upravljanje"
Try
conn.Open()
Dim myCommand As New MySqlCommand
Dim SQL2 As String
SQL2 = "SELECT redbr,sifra, isplata,round(kursevra*isplata )as dinara," _
& "datisplate,kursevra FROM isplate "
myCommand.Connection = conn
myCommand.CommandText = SQL2
Dim mysqlAdapter As New MySqlDataAdapter
mysqlAdapter.SelectCommand = myComman
Dim myData As New DataTable
mysqlAdapter.Fill(myData)
dgPodaci.DataSource = myData
conn.Close()
conn.dispose()
Catch ex As MySqlException
MessageBox.Show("Doslo je do greske", "UPOZORENJE !!!", )
End Try
Dim conn = New MySqlConnection
conn.ConnectionString = "database=upravljanje"
Try
conn.Open()
Dim myCommand As New MySqlCommand
Dim SQL2 As String
SQL2 = "SELECT redbr,sifra, isplata,round(kursevra*isplata )as dinara," _
& "datisplate,kursevra FROM isplate "
myCommand.Connection = conn
myCommand.CommandText = SQL2
Dim mysqlAdapter As New MySqlDataAdapter
mysqlAdapter.SelectCommand = myComman
Dim myData As New DataTable
mysqlAdapter.Fill(myData)
dgPodaci.DataSource = myData
conn.Close()
conn.dispose()
Catch ex As MySqlException
MessageBox.Show("Doslo je do greske", "UPOZORENJE !!!", )
End Try
sos,sos