Last date value (Next Training ) gets properly inserted but not the rest...
any clue?
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/JABILMCALLEN.mdb"
DeleteCommand="DELETE FROM [Certifications] WHERE [CertificationID] = ?"
InsertCommand="INSERT INTO [Certifications] ([EmployeeID], [TrainingDocID], [StartedTraining], [EndedTraining], [EvalutationType], [TrainedBy], [NextTraining], [Approved]) VALUES (?, ?, ?,?,?, ?, ?, ?)"
SelectCommand="SELECT * FROM [Certifications]"
UpdateCommand="UPDATE [Certifications] SET [EmployeeID] = ?, [TrainingDocID] = ?, [Started Training] = ?, [Ended Training] = ?, [EvalutationType] = ?, [TrainedBy] = ?, [NextTraining] = ?, [Approved] = ? WHERE [CertificationID] = ?">
<DeleteParameters>
<asp:Parameter Name="CertificationID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="EmployeeID" Type="Int32" />
<asp:Parameter Name="TrainingDocID" Type="Int32" />
<asp:Parameter Name="Started_Training" Type="DateTime" />
<asp:Parameter Name="Ended_Training" Type="DateTime" />
<asp:Parameter Name="EvalutationType" Type="String" />
<asp:Parameter Name="TrainedBy" Type="String" />
<asp:Parameter Name="NextTraining" Type="DateTime" />
<asp:Parameter Name="Approved" Type="Boolean" />
<asp:Parameter Name="CertificationID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="EmployeeID" Type="Int32" />
<asp:Parameter Name="TrainingDocID" Type="Int32" />
<asp:Parameter Name="StartedTraining" Type="DateTime" />
<asp:Parameter Name="EndedTraining" Type="DateTime" />
<asp:Parameter Name="EvalutationType" Type="String" />
<asp:Parameter Name="TrainedBy" Type="String" />
<asp:Parameter Name="NextTraining" Type="DateTime" />
<asp:Parameter Name="Approved" Type="Boolean" />
</InsertParameters>
</asp:AccessDataSource>