C#資料庫連接顯示

      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.");
            }