在datagridview VB.NET中的列上更改SQL查询中的行 [英] change rows in a SQL query on columns in a datagridview VB.NET

问题描述

我有一个sql查询，其中有数据输入，并想将行转换为datagridview中的列，我该怎么做.

我有一个查询，获取"idStudent" "CodStudent" "NameStudent"和"notes1" "Notes2" "Notes3" "Notes4"并提取为行，我需要将其显示在datagridview中("notes1"，"Notes2"，"Notes3"，"Notes3"，"Notes4")，因为列会帮助我们

I have a sql query where the data come in and want to convert rows into columns in a datagridview how I can do this.

I have a query which gets the "idStudent" "CodStudent" "NameStudent" and "notes1" "Notes2" "Notes3" "Notes4" and extracted as rows and I need to display it in a datagridview ("notes1" "Notes2" "Notes3 "" Notes4 ") as columns help please

推荐答案

尝试一下.其实你的问题是无法理解的.

Try this. Actually your question is not understandable.

TextBox1.Text = datatable.Rows(0).Item("column_name").ToString
TextBox2.Text = datatable.Rows(0).Item("column_name").ToString
...

这篇关于在datagridview VB.NET中的列上更改SQL查询中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！