insert data to the database problem

[gayano]

Hi all I'm Trying this code in vb 2005 express
The database is sql 2005 express
thease textbox are binded with a bindingsource

it does not give me a error but it want insert the data to the database
can anyone help me with this??


Private Sub InsertData()
Dim Truckcode As Integer
Dim TruckNo As String
Dim TruckMake As String
Dim TruckRegDate As Date
Dim TruckOption As String
Dim TruckDriver As String
Dim TruckTons As Integer
Dim TruckSS As Date
Dim TruckSE As Date

Truckcode = txtTruckCode.Text
TruckNo = txtTruckNo.Text
TruckMake = txtTruckMake.Text
TruckRegDate = txtmTruckRegDate.Text
TruckOption = txtTruckOption.Text
TruckDriver = txtTruckDriver.Text
TruckTons = txtTruckTons.Text
TruckSS = txtmTruckSS.Text
TruckSE = txtmTruckSE.Text
Me.TrucksTableAdapter.Insert(Truckcode, TruckNo, TruckMake, TruckRegDate, TruckOption, TruckDriver, TruckTons, TruckSS, TruckSE)
Me.TrucksTableAdapter.Update(AddTrucks.Trucks)
MsgBox("Complete")

End Sub

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Try
InsertData()
Catch ex As Exception
MsgBox(ex)
End Try

End Sub


Thank you

[gayano]

any help would be greatfull

[gayano]

Any help Please
Please