大家好，
我在数据库表里面有3个字段：
id(自动生成),sno学号,sneme姓名,simfomation详细信息！



现在可以连接数据库了！

在dataGridView1里面只显示：sno和sneme,

然后当单击dataGridView1控件里面的时候，对应在一个txtbox1里面把
对应学生信息simfomation，显示出来！！！


怎么实现呀！

谢谢！


  private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
           string connString = @"Data Source=localhost;Initial Catalog=aa11;Integrated Security=True";
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
             = "select Booktext from tb_Book where Booktime=@Booktime  order by ID ASC";
            try
            {
         
               cmd.Parameters.AddWithValue("@Booktime", this.dataGridView1.SelectedCells[1].Value.ToString());

            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }

        
            SqlDataReader sqldr = cmd.ExecuteReader();
            
            if (sqldr.Read())//到这里就直接为假，跳过去了，还怎么读取数据
            {
  
                txtBook.Text = sqldr[1].ToString();
            }
            else
            {
                MessageBox.Show("显示失败");
            }
            conn.Close();
        }

[ 本帖最后由 xiaxun 于 2011-1-6 19:16 编辑 ]

this.textbox1.text=(...."select simfomation from table where sno='"+this.dataGridView1.selectrows[0].cell[0].value.tostring()+"'".....).Tables[0].rows[0]["simfomation "].tostring();//括号中的查询结果应该是个dataset

代码是放在哪个事件里面的

selectionchanged事件

还是显示不成功呀

哪个大哥在帮帮

有源码例子吗

谢谢

然后当单击dataGridView1控件里面的时候，对应在一个txtbox1里面把
对应学生信息simfomation，显示出来！！！

事件不对吧 cellclick

那用哪个事件

select的也不对呀

....俺通常用的都是cellclick celldobleclick 来取选择行的数据?

我不是从数据库控件dataGridView1里面读取数据，而是从数据库表里面直接读取放进 文本框！！
怎么实现呀！
  private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
            string connString = @"Data Source=localhost;Initial Catalog=aa11;Integrated Security=True";
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
             = "select Booktext from tb_Book where Booktime=@Booktime  order by ID ASC";
            try
            {
              
                cmd.Parameters.AddWithValue("@Booktime", Convert.ToDateTime(this.dataGridView1.SelectedCells[1].Value.ToString()));
                cmd.ExecuteScalar();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            //cmd.Parameters.AddWithValue("@id", this.dataGridView1.CurrentCell.RowIndex.ToString());
            SqlDataReader sqldr = cmd.ExecuteReader();
            table2.Clear();
            table2.Load(sqldr);

            SqlDataReader sqldr2 = cmd.ExecuteReader();
            if (sqldr2.Read())
            {

               
                // txtBook.Text = sqldr[1].ToString();
                txtBook.Text = table2.Rows[0][1].ToString();
            }
            else
            {
                MessageBox.Show("显示失败");
            }
            conn.Close();
            
        }
提示说没有声明变量@Booktime，我不是已经用带参数来赋值了吗

[ 本帖最后由 xiaxun 于 2011-1-7 11:00 编辑 ]

建议这样改一下，先试试：

try
            {
              
               @Booktime=Convert.ToDateTime(this.dataGridView1.SelectedCells[1].Value.ToString();//你之前的方法我没有用过，先改成这个试试，或者在外面声明booktime
               
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
= "select Booktext from tb_Book where Booktime="+@Booktime +" order by ID ASC";