Cannot seem to update a GridView (with Datasource).

Question

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)

Khan Abrar Ahmed · Answer

Hi please add the highlighted code add the drop down id in select parameter control id ddlTeacher  runat=server AutoPostBack=True>  SelectCommand= SELECT * FROM [Lessen] WHERE [DocentId] = @DocentId OR @DocentId = -1  UpdateCommand=UPDATE Lessen SET Titel = @Titel Aanvang = @Aanvang Einde = @Einde GroepId = @GroepId ZaalId = @ZaalId DocentId = @DocentId WHERE (Id = @Id)> Name =Titel /> Name =Aanvang /> Name =Einde /> Name =GroepId /> Name =ZaalId /> Name =DocentId /> Name =Id /> PropertyName=SelectedValue Name=DocentId Type=Int32 />

Khan Abrar Ahmed · Answer

So you want to filter the rows with teacher as selected in the drop down list???

Khan Abrar Ahmed · Answer

Yes you have to pass the parameter value.

Khan Abrar Ahmed · Answer

Hi please refer the link http://www.codeproject.com/Articles/667599/Add-Edit-update-Delete-gridview http://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx http://msdn.microsoft.com/en-us/library/ms972948.aspx

Khan Abrar Ahmed · Answer

HI what data you are passing to these Titel = @Titel Aanvang = @Aanvang  Einde = @Einde

Khan Abrar Ahmed · Answer

Hi before update command can you check what value you are passing in the below parameter. because issue with conversion of the value when it is inserting into the table and script is unable to convert with the schema type. Titel = @Titel Aanvang = @Aanvang Einde = @Einde

Anthony Timmers · Answer

Yes for example if I select a teacher with the ID 5 it would only shows rows where the DocentId = 5 I know how to get the selected ID from the Dropdownlist but not how to filter the GridView

Anthony Timmers · Answer

Now I have added a Dropdownlist with teachers (DocentId) how would I make it so that only rows that have the same DocentId as the teacher I select in my dropdownlist?

Anthony Timmers · Answer

I changed it to:  SelectCommand=SELECT * FROM [Lessen] UpdateCommand=UPDATE Lessen SET Titel = @Titel Aanvang = @Aanvang Einde = @Einde GroepId = @GroepId ZaalId = @ZaalId DocentId = @DocentId WHERE (Id = @Id)> Name =Titel /> Name =Aanvang /> Name =Einde /> Name =GroepId /> Name =ZaalId /> Name =DocentId /> Name =Id /> And it seems to work. Is this the correct way?

Anthony Timmers · Answer

The row which is being edited. I found this: Name = ProcessID Type = Int32 DefaultValue = 1234567 /> Name = Process Type = String /> Not sure how I'd use these for my case though.

Anthony Timmers · Answer

I don't have parameters underneath this and am not sure how to add them correctly

Cannot seem to update a GridView (with Datasource).

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

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