Bind with DataRow object

Posted by: nabinpadhi on 8 September 2017, 12:39 pm EST

  • Posted 8 September 2017, 12:39 pm EST

    Hi I am not using any data source to populate the farpoint spread but while saving the data i want to bind DataRow arrayobject with the rows available in farpoint
    Dim Rowswithvalues()  as
    dim internalCnt as integer = 0
    for i as integer =1 to MySpread.ActiveSheet.RowCount -1
         redim preserve Rowswithvalues(internalCnt )
         Rowswithvalues(internalCnt) = MySpread.ActiveSheet.Rows(i)
         internalCnt =internalCnt  +1
    Dim dr() as DataRow

    ======> here i want to import Rowswithvalues into dr

  • Replied 8 September 2017, 12:39 pm EST

    This is not going to work because you can't convert RowswithValues to a 1 dimensional array of a datarow.
  • Replied 8 September 2017, 12:39 pm EST

    If you want to populate a datarow with values from Spread you will need to loop through the rows and columns of each and copy the value that way.
Need extra support?

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

Learn More

Forum Channels