多个Datagridview相关联

 

string  P_Str_cmdtxt  =  String.Empty;
string  P_Str_select  =  String.Empty;
string  strSQL  =  String.Empty; 
// 数据库连接
string  sql  =   " server=172.16.200.33;DataBase=GJMY;uid=sa;pwd=sa; " ;
SqlConnection conn  =   new  SqlConnection(sql);
conn.Open();
// 数据库操作语句,找出数据..
P_Str_select  =   " shijian BETWEEN ' "   +   this .dtStartTime.Value.ToString( " yyyy-MM-dd " )  +   " ' AND " ;
P_Str_select  =   " ' "   +   this .dtEndTime.Value.ToString( " yyyy-MM-dd " )  +   " ' " ;
// strSQL += " and " + P_Str_select + "";
strSQL  =   " select * from PumiShengchan order by id asc " ;

// 适配器,数据集,填充 Datagridview
SqlDataAdapter ads  =   new  SqlDataAdapter(strSQL, conn);
DataSet data  =   new  DataSet();
ads.Fill(data,  " PumiShengchan " );
dataGridView1.DataSource  =  data.Tables[ 0 ];
// Datagridview样式....
             this .dataGridView1.RowsDefaultCellStyle.BackColor  =  Color.Bisque;
             this .dataGridView1.AlternatingRowsDefaultCellStyle.BackColor  =  Color.Beige;
             this .dataGridView1.GridColor  =  Color.BlueViolet;
             this .dataGridView1.BorderStyle  =  BorderStyle.Fixed3D;
            dataGridView1.ReadOnly  =   true ;


private   void  dataGridView1_SelectionChanged( object  sender, EventArgs e)
         ... {
            GridViewBind();
        }

private   void  dataGridView1_CellClick( object  sender, DataGridViewCellEventArgs e)
         ... {
            FillControls();
        }
private   void  FillControls()
         ... {
            this.label1.Text = this.dataGridView1[1, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
            this.label2.Text = this.dataGridView1[2, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
            this.label3.Text = this.dataGridView1[3, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
        }

属性:SelectionMode  >>  FullRowSelect  

第二个datagridview数据填充语句:
GridViewBind()
   ... {
strSQL2 = "select * from PumiShengchan_CP where RelationID='" + dataGridView1.SelectedRows[0].Cells["RelationID"].Value.ToString().Trim() + "'";
  }