private void listdast()
{
sqlConnection1.Open();
listView1.Clear();
listView1.GridLines = true;
listView1.View = View.Details;
cmd = new SqlCommand("select * from Library", sqlConnection1);
dr = cmd.ExecuteReader();
listView1.Columns.Clear();
//增加listview控件的列
listView1.Columns.Add("编号", 80, HorizontalAlignment.Center);
listView1.Columns.Add("书名", 120, HorizontalAlignment.Center);
listView1.Columns.Add("作者", 80, HorizontalAlignment.Center);
listView1.Columns.Add("出版时间", 150, HorizontalAlignment.Center); // 读取DataReader中的数据并输出
while (dr.Read())
{
ListViewItem li = new ListViewItem();
li.SubItems.Clear();
li.SubItems[0].Text = dr["编号"].ToString();
li.SubItems.Add(dr["书名"].ToString());
li.SubItems.Add(dr["作者"].ToString());
li.SubItems.Add(dr["出版时间"].ToString());
listView1.Items.Add(li);
}
}
.
private void Form2_Load(object sender, EventArgs e)
{
listdast();
toolStripComboBox1.SelectedIndex = 0;
da = new SqlDataAdapter("select * from Library",sqlConnection1);
ds.Tables.Add("tab");
da.Fill(ds.Tables["tab"]);
dv = new DataView(ds.Tables["tab"]);
dv.RowFilter = "编号='A'";
dv1 = new DataView(ds.Tables["tab"]);
dv1.RowFilter = "编号='B'"; //------------------------------------------------------------
toolStripComboBox1.ComboBox.DataSource = ds.Tables["tab"];//绑定ds数据
toolStripComboBox1.ComboBox.DisplayMember = "编号";} private void toolStripComboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (toolStripComboBox1.SelectedIndex == 0)
{
//怎么获取 dv = new DataView(ds.Tables["tab"]);
dv.RowFilter = "编号='A'";里面的值呢,
//就是当我点A的时候,怎么获取A的值,显示出Listview里面
//请问这里怎么获取toolStripComboBox1.SelectedIndex == 0的值放在ListView里面呢。???
}在线等,急啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货