Hello world,
i am developing a e-commerce web application.
The structure is :
Products : Database
Shopping cart : Data table
Order : Database
Interface follow this yours tutorial
https://www.aspsnippets.com/Articles/Insert-Save-DataTable-to-SQL-Server-Table-using-C-and-VBNet.aspx
for implement the order and it works fine.
But i want to add a column in the order database called order number, i 've think to use another database called counter,wich have one field that is the progressive number.
From code behind i read this number, add into order database and after make the progressive counter +1 for the next order.
But how can i do this ?
The counter isn't a parameter in the data table, so what can i modify in the store procedure ?
How can i deal this question ?