I need a text/list box to hold a list of information from a database but i want it to be joined so that when there are many items in the box it doesn’t start putting separate scroll in. just one scroll bar for all columns. Like the followinghttp://www.oneapplications.com/images/screenshots/sales_large.gif I would like to achieve this in vb.net so if anyone knows what control this would be that would rock! Dan

 

Are you talking about the grid in the middle of the picture which contains the row 'ASRock K8NFAG Motherboard' along with the price and quantity?

yea

It's a DataGridView that you need

http://msdn.microsoft.com/en-us/library/e0ywh3cz.aspx 

 

The thing is, i dont need it to pull any information from a database, i just need it to list what the user enters like a till system then it will put it into a database when the transaction it complete. something like that. do you have any code that would help me atchieve this as i thought that datagridviews where only for pulling information that is already in a table in a db.

Thanks for your help

Dan

Hi Dan

DataGridViews don't exclusively have to be bound to data from a database.   

Take a look at the following code and see if it makes sense to you.

http://msdn.microsoft.com/en-us/library/system.data.datarow.aspx

In the code, there's a function named MakeNamesTable() which creates a table in code that contains lastname, firstname info. You need to modify this code so that it contains the columns that you need such as ItemDescription, Quantity, and Price. Next modify, theCreateNewDataRow() so that it represents your new data schema.

In the final part of the CreateNewDataRow() procedure, you'll see the following line of code which binds the data that you've completely created in code to the grid.

DataGrid1.DataSource=table

Hope that helps,
Tim

Thanks alot Tim i will try this later today and let you know how i get on

 Dan

No problem Dan. Have you seen this thread on the VB6 forum? Looks like you're not the only one wanting to write a 'till' piece of software!!  

http://www.developerfusion.co.uk/forums/t/54026/

 

 

doesn't surprise me as there is a serious lack in free till systems. And any you buy are quite dull. i am trying to put it together for a few friends but since i have looked in to it, i have found that if i build a semi-attractive one i think it would sell pretty well. i will also build in some other functionality that would give it some selling points as i have several years of experience retail myself. but if i tell you i would have to kill you lol.

 

Dan 

HelpTechIT:

but if i tell you i would have to kill you lol.

 

LOL!! Good luck with the project and I hope it sells!

where you are located mate your profile says you are from the south and i am from folkestone in kent. 

I'm based in Reading, Berkshire