help with VB2005

hammerstein06 · 2007-01-16, 10:26 AM

You should consider looking at a book on databases. There are some good ones covering ADO.NET. It will show you how to properly use databinding. Using the listview incorrectly, you're going to end up writing a lot of the stuff that can be done automatically for you using the correct components.

Look up databinding.

Azimuth · 2007-01-16, 10:43 AM

hammerstein06 Wrote:You should consider looking at a book on databases. There are some good ones covering ADO.NET. It will show you how to properly use databinding. Using the listview incorrectly, you're going to end up writing a lot of the stuff that can be done automatically for you using the correct components.

Look up databinding.

I am relatively familiar with ado.net + sql calls
I guess maybe lack of knowledge about VB control functionality is the key to my problem. maybe a screen shot of the app will help.
I have not found an ideal solution for an editable order list.

hammerstein06 · 2007-01-16, 10:53 AM

try using the DataGridView, it offers a similar look and allows updates / inserts, thus getting rid of all those controls above your items list. VB should walk you through creating the Insert/Update/Delete statements when you create the datasource for the view.

Azimuth · 2007-01-16, 11:01 AM

hammerstein06 Wrote:try using the DataGridView, it offers a similar look and allows updates / inserts, thus getting rid of all those controls above your items list. VB should walk you through creating the Insert/Update/Delete statements when you create the datasource for the view.

I am not a fan of "datasets", I am using direct SQL calls to an mssql engine.
However, I will check that out again, Origionally I ruled that method out because I was under the impression that you could not make datagrids interactive.

Thank you for your ideas, input and help.
I noticfed these were your first posts. Welcome to GBPVR and the forum. This place is great Smile

hammerstein06 · 2007-01-16, 11:14 AM

Thank you for the welcome Smile

I'm new to the world of PVR, what better place to start.

I think the dataset functionality within Visual Studio 2005 is massively increased. There are some good examples lying around, and I find some of the best can be the videos found on MS website.

I'm still learning my way around Dataset functionality, having been thrown in the deep end!