We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Extra row in Data Bound Grid

Thread ID:





44691 May 31,2006 11:42 PM UTC Jun 1,2006 04:07 AM UTC WinForms 1
Tags: GridControl
Jenny Wilson
Asked On May 31, 2006 11:42 PM UTC

Hello, I have a data bound grid which is bound to a data table. I''m using a SQLDataAdapter and the command builder to generate my insert, update and delete statements (in VB). As soon as I edit a row in the grid, a second row is added to the grid, and seems it''s not smart enough to know that this row should not be inserted in the data table yet(RowCount is 2 at this point instead of 1 even though I haven''t even left the row -- and even if I had just tabbed to the next row, seems it would be smart enough to sense that the row is not dirty). It''s trying to insert 2 rows. I''m getting a "Can''t insert null..." SQL error message when the Adapter Update is fired. Only thing I can think of is to create my own Insert and Update statements to exclude rows where a certain column is null, but it doesn''t seem like I should have to do that... My grid is very generic -- the only property I''m setting is the WrapCellBehavior. Any ideas? Thanks, Jenny

Administrator [Syncfusion]
Replied On June 1, 2006 04:07 AM UTC

Hi Jenny, DataTable InsertAt() method is not working.That was an ADO.NET issue and that was resolved in VS2005. Here is a link for that issue: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=170e7fbc-d7d1-460d-bc7d-18e198516566 Here is a sample for two frameworks VS2003 : http://www.syncfusion.com/Support/user/uploads/GridTester2003_e54ed6c8.zip VS2005 : http://www.syncfusion.com/Support/user/uploads/GridTester2005_f407853f.zip Let me know if you need any further assistance. Regards, Haneef


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon