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
AD
Administrator
Syncfusion Team
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
