How do I use the rows of the listbox to display fields and the columns to display data?

No, you can only display data in a field that is bound to a data table.

1 The individual fields of the test table are displayed in the form.

2 Select a field, click Button, and construct an SQL statement in the Button click event"select "+ Selected field name +" from test", run SQL to obtain a dataset, empty the listbox, traverse the dataset and insert it into the listbox, traverse whether the value exists in the listbox before insertion, and skip the insertion if it exists.

If you don't know how to write, you don't need to learn the program.

"column");Add fields.

listviewitem lvi = new listviewitem();Create a listview

;Add the data for the first field.

);Add the data after the second field.

Note that the data for the first field should be based on the text attribute of the listviewitem.

You can copy the part of the table that needs to be swapped first, then create a new table, right-click on the A1 grid--- paste it selectively, and check the "transpose" in the pop-up options and confirm.

Note: Because the number of columns in excel can only be 256 at most, the number of rows you want to swap must be less than 256 rows, otherwise an error will occur.

Select the region of data you want to exchange, select""down"Copy"command, select a blank cell, select""down"Paste special"command, in the dialog box that pops up, click"Transpose"checkbox. Can.

Generally, you don't bind a data source in this way. It's like binding data without griedview. You give people the feeling that you are a rookie, or you are new to the stage of controls. I can't even drag it!

The display data is added manually, bind the corresponding field values to the value, and you can select the columns!

In general database terminology, a record is a row, a field is a column, and records and fields correspond to attributes and tuples in relational databases, respectively.