dataGridView1_CellContentDoubleClick事件处理

 

1.  private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)  

2.         {  

3.             //获取行首的单元格双击事件，并以此值作为传参对象  

4.             string  CellValue = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value .ToString ();  

5.            //MessageBox.Show(CellValue);  

6.               

7.    

8.             SqlConnection con = new SqlConnection(DRIVER);                     

9.             con.Open();  

10.            string strsql = "select id,sid,name,tell,address,shangpinname,shangpinprice,nums,BuyTime from T_customor where id="+CellValue;  

11.            SqlCommand cmd = new SqlCommand(strsql, con);  

12.            SqlDataReader rd = cmd.ExecuteReader();                        

13.           // int id = rd.GetOrdinal("title");                         

14.            while (rd.Read())                                              

15.            {  

16.                this.txt_username.Text = rd["name"].ToString();  

17.                this.txt_tell2.Text = rd["tell"].ToString();  

18.                this.txt_address.Text = rd["address"].ToString();  

19.                this.txt_shangpinname.Text = rd["shangpinname"].ToString();  

20.                this.txt_id.Text = rd["sid"].ToString();  

21.                this.txt_nums.Text = rd["nums"].ToString();  

22.                this.txt_price.Text = rd["shangpinprice"].ToString();  

23.                this .label5 .Text =rd ["id"].ToString ();  

24.   

25.            }  

26.   

27.            tabControl1.SelectTab(tabPage1);  //使tabPage1显示   

28.   

29.   

30.        }