Matrix column data

[Former Member]

hi all,

how to pass the value for a particular column in the matrix from my back end coding?????

oMatrix.Columns.Item("tspent").Cells.Item(iCnt)= 45  //Any Value

like this i want to pass my value from the backend coding..but at this line it's saying error........how to do this???

regards,

shangai.

[Nussi · Accepted solution]

Hi,

i guess you want to do this:

oMatrix.Columns.Item("tspent").Cells.Item(iCnt).Specific.Value = "45"

lg David

[Former Member]

Hi

1) column uid in your matrix is tspent ? I meen what you shoud use item uid.

For iCnt = 1 To oMatrix.VisualRowCount
  oMatrix.Columns.Item("tspent").Cells.Item(iCnt)= 45  //Any Value
Next

2) Or you can do it so:

For iCnt = 1 To oMatrix.VisualRowCount
  oMatrix.GetLineData(iCnt)
  'oMatrix.Columns.Item("tspent").Cells.Item(iCnt)= 45  //Any Value
  oForm.DataSources.UserDataSources.Item("userdatasourcenamehere").Value = 45
  oMatrix.SetLineData(iCnt)
Next

3) Also try to check type and size of the column if you are using userdatasource ...

<userdatasources>
  <action type="add">
    <datasource uid="uTspent" type="9" size="8"/>
      <datasource uid="u_BPCode" type="9" size="15"/>

Regards

Sierdna S.