Spread 3.0 dont make changes to a Dataset

Posted by: jahanzeb-fp on 8 September 2017, 12:49 pm EST

  • Posted 8 September 2017, 12:49 pm EST



    <SPAN><o:p> </o:p></SPAN>

    <SPAN>I have installed the new Version Spread 3 for Windows Forms for my vs2005 (I am a vb User).<o:p></o:p></SPAN>

    <SPAN>It seems to be running good, I was able to bind dataset to the Grid, so it shows me the result I wanted to see, so far so good , BUT!<o:p></o:p></SPAN>

    <SPAN><o:p> </o:p></SPAN>

    <SPAN>I don’t know why, but for some reasons the Grid don’t make Changes to the dataset. <o:p></o:p></SPAN>

    <SPAN>I am using Spread for years now, but I had never this kind of problem.<o:p></o:p></SPAN>

    <SPAN>I even checked the row state for the dataset-row I had changed in the Grid, but the row state is always on “unchanged” , I am confused now.<o:p></o:p></SPAN>

    <SPAN>It this bec of the trial version? Or what is going wrong, hope you can advice<o:p></o:p></SPAN>


  • Replied 8 September 2017, 12:49 pm EST

    Hi Gina

    <SPAN>Does changing rows or going out of edit mode after editing the cell play any role? till now it never played any role, bec after editing the cell press enter or leave the cell, it fires Change() in the Grid, so I don’t understand your point.<o:p></o:p></SPAN>

    <SPAN>I load Data’s in a dataset, and bind it with the Grid , and set the AutoGenerateColumns to <SPAN>False.</SPAN><o:p></o:p></SPAN>

    <SPAN>As I sad, till now it always worked fine, till now I had used Spread 1.1 , now I reinstalled the older version and installed the Spread 3 on my existing project. And it works fine so far, but as I Sad. It doesn’t make any modifications to any dataset any more.</SPAN><SPAN><o:p></o:p></SPAN>

    <SPAN>I even created a new form, just to get sure. I even dropped the new Grid on the form, to avoid any existing Problems from the Older Grid, but the same, the Grind don’t make changes to any dataset.</SPAN><SPAN><o:p></o:p></SPAN>


  • Replied 8 September 2017, 12:49 pm EST

    What type of field/data is in the cell?  You are able to edit the cell with similar data?  Are you changing rows or going out of editmode after editing the cell?  The trial should not be an issue.
  • Replied 8 September 2017, 12:49 pm EST

    Do you have the 3.0.2004.2005 patch?
  • Replied 8 September 2017, 12:49 pm EST


    It sounds like you are not clicking out of the row. That is the trigger for Spread to issue an EndEdit on the bound DataRow object that is being changed. If you need the bound DataSource to update before clicking off the row, you can issue the EndEdit call on the bound DataRow programatically and it will update at that point.

  • Replied 8 September 2017, 12:49 pm EST


    Hi Gina and Scotts


    <SPAN>first of all, yes i already have installed the newest path.<o:p></o:p></SPAN>

    <SPAN>second thing to Scotts, i understand what you explained about the change event, but what i don’t understand is, i used vs2003 and spread 1.0 before, and the "change" event fired always after i pressed enter, also the dataset got the changes, but now i work with vs2005 and spread 3.0 , and it don’t work this way like it works before, all my projects, in each of my forms the change event don’t fire , only when i change the row.. that's really bad for me, now i have to change all my forms again..<o:p></o:p></SPAN>

    <SPAN>I dont know if this was a bug in the spread 1.0 version, but now either the bug is gone, or you changed the behaviour of spread, ever how now I have to reedit all my forms again.<o:p></o:p></SPAN>


  • Replied 8 September 2017, 12:49 pm EST


    For perfomance reasons and to match the behavior of the DataGrid control, we only update the bound DataRow when you click off the row. You can also call the EndEdit method on the DataRow object programatically to 'submit' the DataRow. This is a change from version 1 behavior.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels