how access to all records that have a sheet?

Posted by: melvin on 8 September 2017, 2:01 pm EST

  • Posted 8 September 2017, 2:01 pm EST

    As I go to each column that has a blade, which has been filled from a database, and then this sheet has been amended to create new columns in execution

     for example my data source has columns

    - Country, Description, Price, Amoun

    So I think these new columns and columns for example

    - Total

    then access to all records in the new sheet and then store them in modified database 



  • Replied 8 September 2017, 2:01 pm EST


    I am not able to comprehend the reported issue. Are you trying to total the column values at column footer something like SubTotal.If this is the case, you may try using the built-in SubTotal function.If this does not meet the requirement, please elaborate on the desired behavior.


  • Replied 8 September 2017, 2:01 pm EST

    I'm not trying to create formulas to total, when referred to "total" I referred to the name of the column may well be another name as for example city.

    My problem is that I can not access the records that contain the new leaf
    Property that is not access to each column and get the value to be stored after sending it to the database, in case that the cells have been modified
  • Replied 8 September 2017, 2:01 pm EST

    <FONT face="Times New Roman" size=3>Hello,</FONT>

    <o:p><FONT face="Times New Roman" size=3> </FONT></o:p>

    <FONT face="Times New Roman" size=3>As I have understood, you want to update the modified data back to the database.</FONT>

    <o:p><FONT face="Times New Roman" size=3> </FONT></o:p>

    <FONT face="Times New Roman" size=3>If this is correct, then if you are using Visual Studio 2005/2008 and bound to one of the new VS2005/ VS2008 DataSources, then there is no code needed to update the database. As soon as changes are made in the Spread, the bound DataSource (DataSet/DataTable) would be updated and the database would be updated if you have the UpdateCommand property set on the DataSource. Otherwise you can write SQL commands to get the changes from the Spread on each row change, or better after all row changes (in an event like the Page_PreRender event) and update the database programmatically with the changes.</FONT>

    <o:p><FONT face="Times New Roman" size=3> </FONT></o:p>

    <FONT face="Times New Roman" size=3>Do let me know if I have misunderstood the issue.</FONT>

    <o:p><FONT face="Times New Roman" size=3> </FONT></o:p>

    <FONT face="Times New Roman" size=3>Regards,</FONT>

    <FONT face="Times New Roman" size=3>Amit</FONT>

  • Replied 8 September 2017, 2:01 pm EST

    is exactly what I do, think you can make an example of how they would code
  • Replied 8 September 2017, 2:01 pm EST

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;">Melvin,<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;"><o:p> </o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;">The default samples installed with Spread includes a nice DataBinding sample.<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;"><o:p> </o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;">You can run SpreadWinDemo from here and then choose DataBinding from the Menu dropdown:<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;">C:\Program Files\FarPoint Technologies\Spread.WinForms.4.dotNet20\v4.0.2009\Samples\Cs\SpreadWinDemo<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;"><o:p> </o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;">I would request you to please go through this sample and let us know if it works for you or not.<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;"><o:p> </o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;">Regards,<o:p></o:p></SPAN>

    <SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Verdana;mso-fareast-language:ZH-TW;mso-bidi-font-family:'Courier New';mso-no-proof:yes;">Amit<o:p></o:p></SPAN>

Need extra support?

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

Learn More

Forum Channels