private void GetData(string selectCommand, string connectionString, int flag)
{
SqlDataAdapter da = new SqlDataAdapter(selectCommand, connectionString);
DataSet ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];//直接使用DataSet需要制定具体表ds.Tables[0]
}
private void GetData(string selectCommand, string connectionString)
{
try
{
// Create a new data adapter based on the specified query.
SqlDataAdapter dataAdapter = new SqlDataAdapter(selectCommand, connectionString);
// Create a command builder to generate SQL update, insert, and
// delete commands based on selectCommand. These are used to
// update the database.
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
//table.Locale = System.Globalization.CultureInfo.InvariantCulture;
// 下面三行等同于效果 this.dataGridView1.DataSource = ds.Tables[0];
dataAdapter.Fill(table);
bindingSource1.DataSource = table;
dataGridView1.DataSource = bindingSource1;
// Resize the DataGridView columns to fit the newly loaded content.
//dataGridView1.AutoResizeColumns(
// DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
//dataGridView1.Show();
label1.Text = "bingdingSource-----"+table.Columns[5].ToString();
}
catch (SqlException)
{
MessageBox.Show("To run this example, replace the value of the " +
"connectionString variable with a connection string that is " +
"valid for your system.");
}