我学习了一个程序用的是listbox绑定数据表(DataTable),数据的显示没有问题就是我在点击listbox上的任意数据时,怎么会在下面的文本框动态的显示相应的数据呢?这是效果图:下面是程序代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace DataTableBinding
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{
string connString = @"server=localhost;integrated security=true;database=northwind";
string sql = "select firstname,lastname from employees";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql,conn);
da.Fill(dataSet1, "employees");
DataTable dt = dataSet1.Tables[0];
listBox1.DataSource = dt;
listBox1.DisplayMember = "firstname";
textBox1.DataBindings.Add("text",dt,"firstname");
textBox2.DataBindings.Add("text", dt, "lastname");
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace DataTableBinding
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{
string connString = @"server=localhost;integrated security=true;database=northwind";
string sql = "select firstname,lastname from employees";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql,conn);
da.Fill(dataSet1, "employees");
DataTable dt = dataSet1.Tables[0];
listBox1.DataSource = dt;
listBox1.DisplayMember = "firstname";
textBox1.DataBindings.Add("text",dt,"firstname");
textBox2.DataBindings.Add("text", dt, "lastname");
}
}
}
你找找~
{
textBox1.Text=comboBox1.SelectedItem.ToString()
}希望给楼主一点启示
listBox1.DisplayMember = "employees.firtname";
listBox1.DisplayMember = "employees.firtname";
textBox1.DataBindings.Add("Text",dataSet1,"employees.firtname");
textBox2.DataBindings.Add("Text", dataSet1, "employees.lastname");