0

Hello there.....i just learnt how to use the the oleDb commands to insert into the a database i created from vb.net,but the problem is.....i cannot insert anythin else than OleDbType.VarChar
or i dunno how to insert anything else

this is my code......i need help to insert the value of my datetimepicker to my database

DatAdapter.InsertCommand = New OleDbCommand("INSERT INTO Staff(StaffName,BirthDate,Gender,Address,Phone,Position,StaffID,SystemPassword) VALUES(@StaffName,@BirthDate,@Gender,@Address,@Phone,@Position,@StaffID,@SystemPassword)")
DatAdapter.InsertCommand.Parameters.Add("@StaffName", OleDbType.VarChar, 40, "StaffName")
DatAdapter.InsertCommand.Parameters.Add("@BirthDate", OleDbType.Date, 20, "BirthDate")
DatAdapter.InsertCommand.Parameters.Add("@Gender", OleDbType.VarChar, 40, "Gender")
DatAdapter.InsertCommand.Parameters.Add("@Address", OleDbType.VarChar, 40, "Address")
DatAdapter.InsertCommand.Parameters.Add("@Phone", OleDbType.VarChar, 40, "Phone")
DatAdapter.InsertCommand.Parameters.Add("@Position", OleDbType.VarChar, 40, "Position")
DatAdapter.InsertCommand.Parameters.Add("@SystemPassword", OleDbType.VarChar, 40, "SystemPassword")


DatAdapter.InsertCommand.Parameters.Add("@BirthDate", OleDbType.Date, 20, "BirthDate")

Then My button where all is executed

Dim dr As DataRow
dr= ds.Tables(0).NewRow()

dr("StaffName") = TextBox2.Text
dr("BirthDate") = DateTimePicker1.Value
dr("Gender") = ComboBox1.Text
dr("Address") = TextBox3.Text
dr("Phone") = TextBox4.Text
dr("Position") = ComboBox2.Text
dr("StaffID") = FirstPass.Text
dr("SystemPassword") = SecondPass.Text

ds.Tables(0).Rows.Add(dr)
DatAdapter.Update(ds)
ds.AcceptChanges()

2
Contributors
1
Reply
4
Views
9 Years
Discussion Span
Last Post by Elmo_loves_you
0

Hi ... im fairly new to this aswell so ...

if the date field in your database is set to dateTime then you have to add the date selected from the dateTimePicker in date format

Dim var As Date  'Declare a date variable
var = DateTimePicker1.Value.Date    'Get the date!

dr("BirthDate") = var

Something to that effect :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.