1.通过 SqlDataAdapter赋值
DataTable data = new DataTable();
SqlConnection connection = new SqlConnection(connstr);
string sql = "";
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, connection);
connection.Open();
sqlDataAdapter.Fill(data);
dgvOrder.DataSource = data;
connection.Close();
2.通过SQlDataReader
(1)BindingSource
SqlDataReader reader = SQLHelper.GetReader(sql);
BindingSource source = new BindingSource();
source.DataSource = reader;
dgvOrder.DataSource = source;
(2)DataTable
DataTable data = new DataTable();
SqlDataReader reader = SQLHelper.GetReader(sql);
data.Load(reader);
dgvOrder.DataSource = data;