Question

c#(winform)中如何用sqldatareader数据绑定到datagridview

String connectionString = "Data Source=local;Initial Catalog=TotalManagement;Integrated Security=True";

string selectCommand = "select ID,Name,LawRank,ExecuteDate,ContentType FROM LawsAndRegulations";
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(selectCommand, cn);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();

dataGridViewLaw.DataSource = dr;
dataGridViewLaw.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
这样在datagridview 没有任何显示，

Answer 1

String connectionString = "Data Source=local;Initial Catalog=TotalManagement;Integrated Security=True";

string selectCommand = "select ID,Name,LawRank,ExecuteDate,ContentType FROM LawsAndRegulations";
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlDataAdapter sda = new SqlDataAdapter(selectCommand , cn);
cn.Open();
DataSet dr = cmd.DataAdapter();
sda.Fill(dr);

dataGridViewLaw.DataSource = dr;
dataGridViewLaw.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}

Answer 2

this.datagridview.datasource=dt;
this.datagridview.databand();