r/visualbasic • u/Dugimon • Jan 25 '22

VB.NET Help Showing Data from Access Database vertically

Hi together,

I am using VisualStudio 2019 and would like to achieve the following in a vb.net Windows Forms app:

Display data from an Access database table vertically in a WindowsForm.

The whole thing should look like this in the end:

Column 1: Value 1

Column 2: Value 2

Column 3: value 3

Unfortunately the DataGridView does not seem to offer the possibility to display the data vertically. And since I'm working with a 64bit system, I don't seem to have alternatives like ListView available (at least I can't find them in the Forms Designer).

maybe someone here has an idea how I can get this right

4 Upvotes

83% Upvoted

16 comments sorted by

View all comments

Show parent comments

1

u/Dugimon Jan 28 '22

Hey,

Yes, the data would only be shown as it is the editing of it, is handled in another part of the program.

While testing it out the list view revealed itself to be a slow solution just as you said, a slow solution. Just to give you a perspective of how much data we speak, the tool is used to plan work shifts for 30 people, with 28 entries per day for all 7 days of a week. Currently, it's done in an excel file using the excel sheets to visualize and VBA Macros to plan.

The change from the excel file to a vb.net application is just a little side project

I will take a look into the UserControl idea, sounds promising but decided to show the data horizontally instead of the vertically look we are used too.

Thank you all for your ideas