要在DataGridView中填充复杂查询的结果,可以按照以下步骤进行操作:
DataGridView dataGridView1 = new DataGridView();
this.Controls.Add(dataGridView1);
DataTable dataTable = new DataTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
dataTable.Load(reader);
}
其中,connectionString是连接数据库的字符串,queryString是查询语句。
dataGridView1.DataSource = dataTable;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
完整的示例代码如下:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace WindowsFormsApp
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
FillDataGridview();
}
private void FillDataGridview()
{
DataGridView dataGridView1 = new DataGridView();
this.Controls.Add(dataGridView1);
DataTable dataTable = new DataTable();
string connectionString = "your_connection_string";
string queryString = "your_query_string";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
dataTable.Load(reader);
}
dataGridView1.DataSource = dataTable;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
}
请注意,示例代码中的"your_connection_string"和"your_query_string"需要根据实际情况进行替换。