hi friends...i am developing a small windows application in vb.net using visual studio 2005.
i want to design a form where user can enter multiple records.like we want to design a "bill" form where user can create the bill for any no of items.there are 4 colmns in it : item no , item name , quantity , price.
my requirement is that if user user a particular item from the list of item in first column then the column "item name" get filled automatically from the database.
then user can enter qty , price for that item.on clicking a save button all the data entred by user should get saved in a table in SQL database.
now user can create bill for 1,2 or more items. so no of rows are variable.
HOW could i achieve this using vb.net and SQL server 2005 as databse.