private void button1_Click(object sender, EventArgs e)
{ OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "/" + "DB_student.mdb");
aConnection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("select name from tuser", aConnection);
DataSet dataset = new DataSet();
adapter.Fill(dataset, "name");
listBox1.DataSource = dataset.Tables[0];
listBox1.DisplayMember = dataset.Tables[0].Columns[0].ToString();
listBox1.ValueMember = dataset.Tables[0].Columns[0].ToString();}
想在listbox中显示数据库中的内容,但总是显示不出来,求大神指教
{ OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "/" + "DB_student.mdb");
aConnection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("select name from tuser", aConnection);
DataSet dataset = new DataSet();
adapter.Fill(dataset, "name");
listBox1.DataSource = dataset.Tables[0];
listBox1.DisplayMember = dataset.Tables[0].Columns[0].ToString();
listBox1.ValueMember = dataset.Tables[0].Columns[0].ToString();}
想在listbox中显示数据库中的内容,但总是显示不出来,求大神指教
listBox1.ValueMember = dataset.Tables[0].Columns[0].ColumnName;
//表
String[] sName=new String[dt.Rows.Count];
//成员变量
String[] sId=new String[dt.Rows.Count];
//成员变量
for(int i=0;i<dt.Rows.Count;i++)
{ sName[i]=dt.Rows[i]["name"].ToString();
sId[i]=dt.Rows[i]["id"].ToString();
}
listBox1.Items.AddRange(sName);
private void listBox1_SelectedIndexChanged(object sender,EventArgs e)
{
textBox1.Text=sId[listBox1.SelectedIndex];
}