in my asp.net+vb web in a gridview when i try to update the above error comes.i am using sqldatasource for gridview and code is as under
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BaijuEP %>"
SelectCommand="SELECT * FROM [Rum] WHERE ([perno] = @perno)order by id,status"
DeleteCommand="DELETE FROM [Rum] WHERE [id] = @id"
InsertCommand="INSERT INTO [Rum] ([perno], [Status], [Days], [Out_dt], [In_dt], [lvefrom], [lveto], [prefixfrom], [prefixto], [sufixfrom], [sufixto], [Year_], [eff_dt]) VALUES (@perno, @Status, @Days, @Out_dt, @In_dt, @lvefrom, @lveto, @prefixfrom, @prefixto, @sufixfrom, @sufixto, @Year_, @eff_dt)"
UpdateCommand="UPDATE [Rum] SET [perno] = @perno, [Status] = @Status, [Days] = @Days, [Out_dt] = @Out_dt, [In_dt] = @In_dt, [lvefrom] = @lvefrom, [lveto] = @lveto, [prefixfrom] = @prefixfrom, [prefixto] = @prefixto, [sufixfrom] = @sufixfrom, [sufixto] = @sufixto, [Year_] = @Year_, [eff_dt] = @eff_dt WHERE [id] = @id">
<SelectParameters>
<asp:ControlParameter ControlID="indltxt" Name="perno" PropertyName="Text"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="perno" Type="String" />
<asp:Parameter Name="Status" Type="String" />
<asp:Parameter Name="Days" Type="Int32" />
<asp:Parameter DbType="Datetime" Name="Out_dt" />
<asp:Parameter DbType="Date" Name="In_dt" />
<asp:Parameter DbType="Date" Name="lvefrom" />
<asp:Parameter DbType="Date" Name="lveto" />
<asp:Parameter Name="prefixfrom" Type="String" />
<asp:Parameter Name="prefixto" Type="String" />
<asp:Parameter Name="sufixfrom" Type="String" />
<asp:Parameter Name="sufixto" Type="String" />
<asp:Parameter Name="Year_" Type="String" />
<asp:Parameter DbType="Date" Name="eff_dt" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="perno" Type="String" />
<asp:Parameter Name="Status" Type="String" />
<asp:Parameter Name="Days" Type="Int32" />
<asp:Parameter DbType="Date" Name="Out_dt" />
<asp:Parameter DbType="Date" Name="In_dt" />
<asp:Parameter DbType="Date" Name="lvefrom" />
<asp:Parameter DbType="Date" Name="lveto" />
<asp:Parameter Name="prefixfrom" Type="String" />
<asp:Parameter Name="prefixto" Type="String" />
<asp:Parameter Name="sufixfrom" Type="String" />
<asp:Parameter Name="sufixto" Type="String" />
<asp:Parameter Name="Year_" Type="String" />
<asp:Parameter DbType="Date" Name="eff_dt" />
</InsertParameters>
</asp:SqlDataSource>