Anthony Timmers

Anthony Timmers

  • NA
  • 11
  • 1.4k

Cannot seem to update a GridView (with Datasource).

May 25 2014 6:12 AM
I think I have made mistakes in the UpdateCommand so I'll post it here:

[code]<asp:SqlDataSource ID="LessenDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:LessenConnection %>" SelectCommand="SELECT * FROM [Lessen]" UpdateCommand="UPDATE Lessen SET Titel = @Titel, Aanvang = @Aanvang, Einde = @Einde, GroepId = @GroepId, ZaalId = @ZaalId, DocentId = @DocentId WHERE (Id = @Id)"></asp:SqlDataSource>[/code]
 
Titel = nvarchar, Aanvang = DateTime, Einde = DateTime, GroepId = int, ZaalId = int, DocentId = int
 
When I try to edit a field I get the following error:
 
 

The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

 
https://www.dropbox.com/s/wrw6a2d7cro8s9q/GridView.bmp (Image of how the GridView looks) 

Answers (11)