Hi David, I got this error: System.Data.Index' is not accessible in this context because it is 'Private'.

Hello, I am not able to convert this function to VB code.... This is the javascript function to get the last digit of a GTIN number:

factor = 3;
sum = 0;

var gNum = '1234564020233'

    for (index = gNum; index > 0; --index) {
        sum = sum + gNum.substring(index - 1, index) \* factor;
        factor = 4 - factor;
    }
    cc = ((1000 - sum) % 10);

    result = gNum + cc;
   
    }

I have the problem to deal with the substring function. Anyone can help?

Thanks for your reply, I able to create the row number column but when I tried to select a range of row number. It appeared this error message " Conversion failed when converting the varchar value 'Row_Number' to data type int" I have used cast and convert already. Any idea? Tin

Hi All, I know "TOP" Function can select the TOP n records. How can I select records from for example 20 to 50? I know SQL server doesn't have "LIMIT" Function.... Thanks Tin

Thanks for your reply, Dave. The dataset is retrieved from database. What I am trying to do is select the Top 50 records in database then show the top 20 into a datalist and the rest in another datalist. I know in SQL server doesn't have the "LIMIT" function. Thats why I don't know how to get those 30 records. Thanks Tin

Hi All, I have created a dataset which contains 50 records. I want to put the first 20 records in one datatable and the last 30 records into another datatable. I don't know how to do it. anyone has idea? Thanks Tin