从数据库中读取表格全部的列名并在datagridview中显示对应的列与列名

以下是使用C#语言读取数据库中表格列名，并在DataGridView中显示对应列名的代码示例：

首先，连接到数据库并打开连接：

string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

查询表格的列名：

string tableName = "myTable";
string query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "'";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();

将列名添加到DataGridView中：

while (reader.Read())
{
    string columnName = reader.GetString(0);
    dataGridView1.Columns.Add(columnName, columnName);
}

关闭连接：

reader.Close();
connection.Close();

完整的代码示例：

string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

string tableName = "myTable";
string query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "'";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    string columnName = reader.GetString(0);
    dataGridView1.Columns.Add(columnName, columnName);
}

reader.Close();
connection.Close();