I am creating a till system (EPOS system) in vb.net
I have a textbox and a datagrid and I am using SQL Server 2005 as a DBMS.
I have already managed to retrieve data into the datagrid by typing in an item number into the textbox, hitting a button, and the items details are retrieved into the datagrid.
Now the problem arises once I type in another item number into the text box. The details of the new item replace the current details already in the datagrid.
How could I do it so that all the different item details stay in the datagrid?
Is it possible?
I have tried looking in previous posts but couldnt find any aid for this problem
Thanks guys, I appreciate your help