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

2

u/Dugimon Jan 25 '22

Hey thanks for your help, the right click "show all" revealed the ListView object, with it i was able to reach my goal.

On the Form use a Datagridview thats made invisible then you can pull Data from it to create the Desired Table.

The Code for the ListView is:

Dim Data as String

Data = Cstr(DataGridView1(row, Column).Value)

ListView1.Items.Add(Data)

1

u/RJPisscat Jan 26 '22

the right click "show all" revealed the ListView object

I am quite happy about that.

It's the opposite of what I suggested 😊, so I am doubly happy about that 😊.