---恢复内容开始---五道口 北大青鸟校区KTV项目指导老师: 袁玉明 SQL数据库关系图 第一步: 1 private void DoubleClicklvContry() 2 { 3 if (this.lvtype.Selected ...
---恢复内容开始---
五道口 北大青鸟校区
KTV项目
指导老师: 袁玉明
SQL数据库关系图
第一步:
1 private void DoubleClicklvContry() 2 { 3 if (this.lvtype.SelectedItems[0]!=null) 4 { 5 this.lvContry.Visible = true; 6 this.lvtype.Visible = false; 7 type = this.lvtype.SelectedItems[0].Tag.ToString(); 8 this.lvContry.Location = this.lvtype.Location; 9 lvContry.Dock = DockStyle.Fill; 10 } 11 get='_blank'>string sql = "select singertype_id,singertype_name,singertype_imageURL from singer_type"; 12 cmd = new SqlCommand(sql, con.Conntion); 13 try 14 { 15 con.OpenConntion(); 16 SqlDataReader reader = cmd.ExecuteReader(); 17 if (this.lvContry.Items != null) 18 { 19 lvSinger.Items.Clear(); 20 } 21 if (reader.HasRows) 22 { 23 int index = 0; 24 while (reader.Read()) 25 { 26 ListViewItem item = new ListViewItem(); 27 item.Text = reader[1].ToString(); 28 item.Tag = reader[0].ToString(); 29 this.imageList2.Images.Add(Image.FromFile(@"E:\KTV\SingerTypeIamge\" + reader[2].ToString())); 30 item.ImageIndex =index; 31 this.lvContry.Items.Add(item); 32 index++; 33 } 34 } 35 reader.Close(); 36 } 37 catch (Exception ex) 38 { 39 MessageBox.Show(ex.Message); 40 } 41 finally 42 { 43 con.CloseConntion(); 44 } 45 } 46 47 48 第二部: 49 private void lvtype_DoubleClick_1(object sender, EventArgs e) 50 { 51 DoubleClicklvContry(); 52 } 53 /// <summary> 54 /// 给lvSinger添加数据 55 /// </summary> 56 private void DoubleClicklvSinger() 57 { 58 if (this.lvContry.SelectedItems[0]!=null) 59 { 60 this.lvSinger.Visible = true; 61 this.lvContry.Visible = false; 62 this.lvSinger.Location = this.lvContry.Location; 63 this.lvSinger.Dock = DockStyle.Fill; 64 65 string sql = string.Format("select singer_id,singer_name,singer_photo_url from singer_info where singer_sex='{0}' and singertype_id={1}", 66 type,Convert.ToInt32(this.lvContry.SelectedItems[0].Tag)); 67 cmd=new SqlCommand(sql,con.Conntion); 68 try 69 { 70 con.OpenConntion(); 71 //imageList3.Images.Clear(); 72 SqlDataReader reader = cmd.ExecuteReader(); 73 if (this.lvSinger.Items!=null) 74 { 75 lvSinger.Items.Clear(); 76 } 77 if (reader.HasRows) 78 { 79 int index = 0; 80 while (reader.Read()) 81 { 82 ListViewItem item = new ListViewItem(); 83 item.Text = reader[1].ToString(); 84 item.Tag = reader[0].ToString(); 85 this.imageList3.Images.Add(Image.FromFile(@"E:\KTV\singerPhoto\" + reader[2].ToString())); 86 item.ImageIndex = index; 87 this.lvSinger.Items.Add(item); 88 index++; 89 } 90 } 91 reader.Close(); 92 } 93 catch (Exception ex) 94 { 95 MessageBox.Show(ex.Message); 96 } 97 finally { 98 con.CloseConntion(); 99 }100 }101 }102 103
原标题:C# KTV 系统 SQL数据库连接 C# 应用窗体
关键词:C#
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。