DataGridView数据动态绑定

 

            try
            {
                string ConnStr;
                SqlConnection Conn = new SqlConnection();
                SqlCommand Command = new SqlCommand();
                SqlDataAdapter Da;
                DataSet dt = new DataSet();
                SqlDataReader SqlReader;
         

                ConnStr = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI";
                Conn.ConnectionString = ConnStr;
                Conn.Open();

                Command.Connection = Conn;
                Command.CommandText = "Select [Orders].OrderID  as 订单号 ,Quantity as 质量 From Orders,[Order Details] where Orders.OrderID=[Order Details].OrderID";
                //MessageBox.Show(Conn.State.ToString());
                //SqlReader = Command.ExecuteReader();
                Da = new SqlDataAdapter(Command);
                
                Da.Fill(dt, "MyTable");
                dataGridView1.DataSource = dt;
                dataGridView1.DataMember = "MyTable";
                textBox1.DataBindings.Add("Text", dt, "MyTable.质量"); //数据绑定
                comboBox1.DataSource = dt;
                comboBox1.DisplayMember = "MyTable.订单号";
                comboBox1.ValueMember = "MyTable.订单号"; 
                dt.WriteXml("c:\\test.xml");
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                //m_Reader.Close();
                //m_Conn.Close();
            }