从数据库中获取表格的列名和列数并在datagridview中显示

以下是一个示例代码，它演示了如何从数据库中获取表格的列名和列数并在DataGridView中显示。

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Data Source=your_server_name;Initial Catalog=your_database_name;User ID=your_user_name;Password=your_password;";
            string tableName = "your_table_name";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                // Get the column names and column count
                string query = $"SELECT * FROM {tableName} WHERE 1=0";
                SqlCommand command = new SqlCommand(query, connection);
                SqlDataReader dataReader = command.ExecuteReader();
                DataTable schemaTable = dataReader.GetSchemaTable();
                int columnCount = schemaTable.Rows.Count;
                string[] columnNames = new string[columnCount];

                for (int i = 0; i < columnCount; i++)
                {
                    columnNames[i] = schemaTable.Rows[i]["ColumnName"].ToString();
                }

                dataReader.Close();

                // Fill the DataGridView with data from the table
                SqlDataAdapter dataAdapter = new SqlDataAdapter($"SELECT * FROM {tableName}", connection);
                DataTable dataTable = new DataTable();
                dataAdapter.Fill(dataTable);

                dataGridView1.DataSource = dataTable;
                dataGridView1.AutoGenerateColumns = false;

                for (int i = 0; i < columnCount; i++)
                {
                    dataGridView1.Columns[i].HeaderText = columnNames[i];
                    dataGridView1.Columns[i].DataPropertyName = columnNames[i];
                }
            }
        }
    }
}