Generate Reference Number from Database Table

I am a beginner in ASP.NET using VB Code. I want to generate a Unique reference no by concortinating three column fields.

Example:

1. Column unique reference no (System Generated) - 10
2. Column with Produc开发者_开发知识库t Code (User Entry) - APPLE

3. Column with Product Title (User Entry) - FRUITS

4. Unique ref No = FRUITS/APPLE/10

I want to concatenate this three fields to the column Unique Ref No.

Use calculated column - at database level or at dataset level as per your requirements.