[C #] how to display the query result of the datagridview as an alias (non-database column name)

 

There are two methods: (1) the SQL statement to be queriedCodeTime: String SQL = "select username as name, usernum as number, userclass as department from userinfo"; (Chinese is displayed ). (2) interface operation: drag and drop the dview control in the form, and you will see a small triangle in the upper right corner of the datagridview control. Click the small triangle to see the "datagridview task ", select "Edit column". In the pop-up "Edit column window", click "add" to add several columns, select a column from "selected columns" on the left, and then select (input): Data: datapropertyname (column name in the table) in "unbound column attributes" on the right. Appearance: headertext (Chinese name to be displayed ).