Assign sequence number for each data row that load on the datagrid.
-
Through the system i develop, i need to bind all related data onto the datagrid after getting related search data from previous page from user. After bind the search result on the datagrid from my MS SQL SERVER 2000 databse, i will keep checking and assiging the sequence number to each row of data from the datagrid. The sequenced number in format (PB1-000000). The first 3 character is category group, then the following 6 digit will generate sequencely row by row. Any idea for me, please? Thank for response.
-
Through the system i develop, i need to bind all related data onto the datagrid after getting related search data from previous page from user. After bind the search result on the datagrid from my MS SQL SERVER 2000 databse, i will keep checking and assiging the sequence number to each row of data from the datagrid. The sequenced number in format (PB1-000000). The first 3 character is category group, then the following 6 digit will generate sequencely row by row. Any idea for me, please? Thank for response.