Skip to Content
0
Former Member
Apr 03, 2008 at 12:45 PM

How to fill the first column '#' of matrix with row id in user form?

38 Views

Hi All,

I am having a user defined form in which, I m having a matrix and m populating the matrix with the output of an sql query.

something like this:

SQL_Str= "select col1,col2,......from.... "

OPopDBTable.ExecuteQuery(SQL_Str)

oMatrix.AddRow()

oMatrix.Columns.Item("Col3").DataBind.Bind("PopTable", "col1")

oMatrix.Columns.Item("Col2").DataBind.Bind("PopTable", "col2")

oMatrix.LoadFromDataSource()

Now, in this, how can I assign row number to first column ('#' column ) ??

regards,

Binita