学步园

建表：Class1

列名：naem,sex,age,address,Email,........。

为表填充数据

放上对应的 textBox  绑定对应列，

然后放上三个textBox 再分别绑定sex  address Email...

再放上一个comboBox .三个button 

注：下面的dataSet31  为集合，Class1 为表……

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace My_SQL
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.dataSet31, "Class1"].Position--;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.dataSet31, "Class1"].Position++;
        }

        private void Form3_Load(object sender, EventArgs e)
        {
            comboBox1.Items.Clear();
            comboBox1.DataSource = dataSet31.Tables["Class1"];
            comboBox1.DisplayMember = "Naem";
            this.sqlDataAdapter1.Fill(this.dataSet31, 0, 0, "Class1");
        }

        private void button3_Click(object sender, EventArgs e)
        {
            int dds = comboBox1.SelectedIndex;
            string ds = comboBox1.Text;
            SqlConnection con1 = new SqlConnection("Data Source=(local);database=msdb;Integrated Security=SSPI");
            SqlCommand cmd = new SqlCommand("select Age,sex,address from Class1 where naem='"+ds+"'", con1);
            con1.Open();
            SqlDataReader  dr=cmd.ExecuteReader();
            if (dr.Read())
            {
                this.textBox7.Text = dr[1].ToString();
                this.textBox8.Text = dr[2].ToString();
                this.textBox6.Text = dr[0].ToString();
                this.BindingContext[this.dataSet31, "Class1"].Position = dds;
            }
            dr.Close();
            con1.Close();
        }
    }
}

F5运行，试着改变comboBox1的值，再点button3 ，多试几次，看看有什么结果？

请问comboBox1里面的东西这是仲么了……。

试过这个把 this.BindingContext[this.dataSet31,"Class1"].Position =dds;  注掉再试一下看看，

取消   this.BindingContext[this.dataSet31,"Class1"].Position =dds;  的注释

把后面加上的三个textBox  去掉绑定……。再来看一下。

请问这是怎么回事，究竟comboBox1里面的东西那来的？？？