Rowupdating index was out of range

How do I get the old values in a gridview row in the row_updating event? But it doesn't work for index items greater than 0. Must be non-negative and less than the size of the collection. I'm using a sqldatasource control to populate the grid and want to write the update code in the Row Updating event. I can get the value of the first field using string old_Category = e. To String(); it returns an error message Index was out of range. ID="Grid View1" runat="server" Auto Generate Columns="False" Data Source ID="Sql Data Source1" Border Width="0px" Border Style="None" Width="100%" Cell Padding="2" Page Size="25" On Row Deleting="Project List Grid View_Row Deleting" onrowdatabound="Grid View1_Row Data Bound" onrowupdating="Grid View1_Row Updating" onrowediting="Grid View1_Row Editing" ID="Drop Down List1" runat="server" Data Source ID="sds Ddl Projects Edit" Data Text Field="Project Name" Data Value Field="Project ID" Auto Post Back="True" onselectedindexchanged="Drop Down List1_Selected Index Changed" " Select Command="SELECT @Week Ending Week Ending , Project , Project ID , Category , Category ID ,isnull([1], 0) Sun ,isnull([2], 0) Mon ,isnull([3], 0) Tue ,isnull([4], 0) Wed ,isnull([5], 0) Thu ,isnull([6], 0) Fri ,isnull([7], 0) Sat from (select P. Time Entry Duration Hours FROM dbo.aspnet_starterkits_Time Entry TE inner join dbo.aspnet_starterkits_Project Categories CAT on TE. Category ID inner join dbo.aspnet_starterkits_Projects P on CAT. Must be non-negative and less than the size of the collection. Parameter name: index"的关于数据索引值错误的问题,在网上查了许多,感觉都没有什么文章是直接指出解决问题的方法,先就总结下吧其实,这个问题在操作时是需要非常注意的,它并不在Grid View控件的Row Editing或者Row Updating方法中,而是需要在获取数据的类中指定Grid View控件的主键,后台代码如部分如下: 1 using System; 2 using System. The problem is the when the Grid api wants to work. I had placed the update/cancel buttons in the Footer....

Thus, in order to switch it into Edit Mode, in each of your event handles (Row Editing, Row Updating, and Row Canceling Edit) you must do two things: Protected Sub Grid View1_Row Editing(By Val sender As System. aspdotnet-suresh offers C#articles and tutorials,csharp dot net,articles and tutorials, VB.protected void Grid View1_Row Editing(object sender, Grid View Edit Event Args e) { Grid View1. New Edit Index; Sql Connection con = new Sql Connection("Data Source=MEHDI-PC\SQLEXPRESS; Initial Catalog=PIMS; Integrated Security=True"); string sql = "select [Dwg Reg ID],[Ref],[Dwg_Ref],[Title],[Dwg_Received_Date],[Rev],[Trade],[Type],[Produced_Date],[Produced_By],[Submittal_Ref],[Issued_To],[Date_Issued],[Purpose],[Status],[Action_Date] from dbo. Open(); Sql Data Adapter adp = new Sql Data Adapter(sql, con); Data Set ds = new Data Set(); adp. Today was spent mostly tackling the Grid View’s Update/Edit functionality, and I got incredibly frustrated, at first. So be sure to rebind your Grid View at the end of your event handler. I’ve got a pretty good handle on it as I’ve been doing it for several years, and can help with a lot, but I definitely don’t claim to know everything.

Leave a Reply