代码
1 string connString2 = "Data Source=.;Initial Catalog=music;Persist Security Info=True;User ID=sa;Password=sa";
2
3 private void testForm_Load(object sender, EventArgs e)
4 {
5 DataSet ds = new DataSet();
6 ds = Kugou.Data.DBHelper.GetDataSet(connString2, "select songid,songname,singer from song");
7 listView1.GridLines = true;
8 listView1.FullRowSelect = true;
9 listView1.View = View.Details;
10 listView1.Scrollable = true;a
11 listView1.MultiSelect = false;
12 listView1.HeaderStyle = ColumnHeaderStyle.Nonclickable;
13
14 listView1.Columns.Add("歌曲ID", 60, HorizontalAlignment.Center);
15 listView1.Columns.Add("歌曲名称", 200, HorizontalAlignment.Center);
16 listView1.Columns.Add("歌手名称", 200, HorizontalAlignment.Center);
17
18 listView1.Visible = true;
19
20 foreach (DataRow dr in ds.Tables[0].Rows)
21 {
22 ListViewItem item = new ListViewItem();
23 item.SubItems.Clear();
24 item.SubItems[0].Text = dr["songid"].ToString();
25 item.SubItems.Add(dr["songname"].ToString());
26 item.SubItems.Add(dr["singer"].ToString());
27
28 listView1.Items.Add(item);
29 }
30 }
31
32 private void listView1_Click(object sender, EventArgs e)
33 {
34 int index = int.Parse(this.listView1.SelectedIndices[0].ToString()); //获取当前项的序号
35 label1.Text = listView1.Items[index].SubItems[0].Text + "-" + listView1.Items[index].SubItems[1].Text + "-" + listView1.Items[index].SubItems[2].Text; //获取其中内容
36 }
37
2
3 private void testForm_Load(object sender, EventArgs e)
4 {
5 DataSet ds = new DataSet();
6 ds = Kugou.Data.DBHelper.GetDataSet(connString2, "select songid,songname,singer from song");
7 listView1.GridLines = true;
8 listView1.FullRowSelect = true;
9 listView1.View = View.Details;
10 listView1.Scrollable = true;a
11 listView1.MultiSelect = false;
12 listView1.HeaderStyle = ColumnHeaderStyle.Nonclickable;
13
14 listView1.Columns.Add("歌曲ID", 60, HorizontalAlignment.Center);
15 listView1.Columns.Add("歌曲名称", 200, HorizontalAlignment.Center);
16 listView1.Columns.Add("歌手名称", 200, HorizontalAlignment.Center);
17
18 listView1.Visible = true;
19
20 foreach (DataRow dr in ds.Tables[0].Rows)
21 {
22 ListViewItem item = new ListViewItem();
23 item.SubItems.Clear();
24 item.SubItems[0].Text = dr["songid"].ToString();
25 item.SubItems.Add(dr["songname"].ToString());
26 item.SubItems.Add(dr["singer"].ToString());
27
28 listView1.Items.Add(item);
29 }
30 }
31
32 private void listView1_Click(object sender, EventArgs e)
33 {
34 int index = int.Parse(this.listView1.SelectedIndices[0].ToString()); //获取当前项的序号
35 label1.Text = listView1.Items[index].SubItems[0].Text + "-" + listView1.Items[index].SubItems[1].Text + "-" + listView1.Items[index].SubItems[2].Text; //获取其中内容
36 }
37