建表: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里面的东西那来的???