25-06-15, 07:13 PM
اضف # في بداية ونهاية التاريخ
كود :
cmd.Editdata("insert into car2 ( carID2 , ahda , monName , price , paky , date) VALUES ('" & DataGridView1.Rows(I).Cells(0).Value & "' , '" _
& DataGridView1.Rows(I).Cells(1).Value & "' , '" & DataGridView1.Rows(I).Cells(2).Value & "' , '" & DataGridView1.Rows(I).Cells(3).Value & "' , '" _
& DataGridView1.Rows(I).Cells(4).Value & "' , '#" & DataGridView1.Rows(I).Cells(5).Value("0000-00-00 00:00:00") & "#' )")
