Bojan11 Pula,HR
Član broj: 73881 Poruke: 180 *.adsl.net.t-com.hr.
|
Sada pokušavam sa:
taj kod mi Windowsi generiraju , prilikom stvaranja Dataseta...
'OleDbInsertCommand1
'
Me.OleDbInsertCommand1.CommandText = "INSERT INTO KORISNICI(Aktivnost, [Datum upisa], Kartica, [Korisnik DNT-a], [PIN k" & _
"od], Ugovor) VALUES (?, ?, ?, ?, ?, ?)"
Me.OleDbInsertCommand1.Connection = Me.OleDbConnection1
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Aktivnost", System.Data.OleDb.OleDbType.Boolean, 2, "Aktivnost"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Datum_upisa", System.Data.OleDb.OleDbType.DBDate, 0, "Datum upisa"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Kartica", System.Data.OleDb.OleDbType.Integer, 0, "Kartica"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Korisnik_DNT_a", System.Data.OleDb.OleDbType.VarWChar, 50, "Korisnik DNT-a"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PIN_kod", System.Data.OleDb.OleDbType.Integer, 0, "PIN kod"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Ugovor", System.Data.OleDb.OleDbType.VarWChar, 50, "Ugovor"))
pa ako mi netko može reći di sad ja moram ubacit svoje Texbox1-ove za unos.....
i dali trebam prije ovoga u Buton kontroli napraviti Select Command?? Hvala
|