双击dataGridView1中任意的单元格触发

来源:互联网 发布:python read 长度 编辑:程序博客网 时间:2024/06/05 11:43
 
 private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)        {            //获取行首的单元格双击事件,并以此值作为传参对象            string  CellValue = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value .ToString ();           //MessageBox.Show(CellValue);                        SqlConnection con = new SqlConnection(DRIVER);            con.Open();            string strsql = "select id,sid,name,tell,address,shangpinname,shangpinprice,nums,BuyTime from T_customor where id="+CellValue;            SqlCommand cmd = new SqlCommand(strsql, con);            SqlDataReader rd = cmd.ExecuteReader();           // int id = rd.GetOrdinal("title");            while (rd.Read())            {                this.txt_username.Text = rd["name"].ToString();                this.txt_tell2.Text = rd["tell"].ToString();                this.txt_address.Text = rd["address"].ToString();                this.txt_shangpinname.Text = rd["shangpinname"].ToString();                this.txt_id.Text = rd["sid"].ToString();                this.txt_nums.Text = rd["nums"].ToString();                this.txt_price.Text = rd["shangpinprice"].ToString();                this .label5 .Text =rd ["id"].ToString ();            }            tabControl1.SelectTab(tabPage1);  //使tabPage1显示         }

原创粉丝点击