znam da sam vec dosadan s ovim al eto da pitam kakva me to glupost muci.
access 2000
vs.net 2003, framework 1.1
Code:
Dim konekcija As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=C:\Documents
and Settings\Digitall\Desktop\vb.net primjeri\baza\db1.mdb")
Dim adapter As New OleDbDataAdapter("select * from Korisnici", konekcija)
Dim dset As New DataSet()
Dim komanda As OleDbCommand = New OleDbCommand()
komanda.Connection = konekcija
komanda.CommandText = "INSERT INTO Korisnici " & _
"(Username, Password, Ime, prezime) " & _
"VALUES('dffsf', 'sdad', 'sdadasd', 'dddd') "
konekcija.Open()
komanda.ExecuteNonQuery()
konekcija.Close()
javi gresku na executeNonQuery kaze unhandled exeption bla bla
kad idem ovako:
Code:
Dim konekcija As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=C:\Documents
and Settings\Digitall\Desktop\vb.net primjeri\baza\db1.mdb")
Dim adapter As New OleDbDataAdapter("select * from Korisnici", konekcija)
Dim dset As New DataSet()
Dim komanda As OleDbCommand = New OleDbCommand()
adapter.Fill(dset, "Korisnici")
Dim red As DataRow = dset.Tables("Korisnici").NewRow()
'Dim tablica As DataTable
Dim var As String
red("Username") = "Usernama"
red("Password") = "password"
red("Ime") = "imeeee"
red("Prezime") = "prezimeee"
dset.Tables("Korisnici").Rows.Add(red)
adapter.Update(dset)
onda mi javi ovo:
An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll
Additional information: Update unable to find TableMapping['Table'] or DataTable 'Table'.
ali sam primetio da u dataset-u ubaci novi red bez problema
kad idem ovako:
Code:
Dim table As DataTable
Dim row As DataRow
table = dset.Tables.Item(0)
row = table.NewRow()
row("Username") = "userrfg"
row("Password") = "Pdfdf"
row("Ime") = "IEMEE"
table.Rows.Add(row)
adapter.Update(dset)
javi opet isto
u cemu je greska?
predpostavljam da mi nije definisana update komanda.. kako da to napravim ako je to u pitanju?