C# KTV 系统 SQL数据库连接 C# 应用窗体

---恢复内容开始---

五道口 北大青鸟校区

KTV项目

指导老师: 袁玉明

 SQL数据库关系图

 

第一步:

 private void DoubleClicklvContry() 
        {
            if (this.lvtype.SelectedItems[0]!=null)
            {
                this.lvContry.Visible = true;
                this.lvtype.Visible = false;
                type = this.lvtype.SelectedItems[0].Tag.ToString();
                this.lvContry.Location = this.lvtype.Location;
                lvContry.Dock = DockStyle.Fill;
            }
            string sql = "select singertype_id,singertype_name,singertype_imageURL from singer_type";
            cmd = new SqlCommand(sql, con.Conntion);
            try
            {
                con.OpenConntion();
                SqlDataReader reader = cmd.ExecuteReader();
                if (this.lvContry.Items != null)
                {
                    lvSinger.Items.Clear();
                }
                if (reader.HasRows)
                {
                    int index = 0;
                    while (reader.Read())
                    {
                        ListViewItem item = new ListViewItem();
                        item.Text = reader[1].ToString();
                        item.Tag = reader[0].ToString(); 
                        this.imageList2.Images.Add(Image.FromFile(@"E:KTVSingerTypeIamge" + reader[2].ToString()));
                        item.ImageIndex =index;
                        this.lvContry.Items.Add(item);
                        index++;
                    }
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally 
            {
                con.CloseConntion();
            }
        }


第二部:
        private void lvtype_DoubleClick_1(object sender, EventArgs e)
        {
            DoubleClicklvContry();
        }
        /// <summary>
        /// 给lvSinger添加数据
        /// </summary>
        private void DoubleClicklvSinger() 
        {
            if (this.lvContry.SelectedItems[0]!=null)
            {
                this.lvSinger.Visible = true;
                this.lvContry.Visible = false;
                this.lvSinger.Location = this.lvContry.Location;
                this.lvSinger.Dock = DockStyle.Fill;

                string sql = string.Format("select singer_id,singer_name,singer_photo_url from singer_info where singer_sex='{0}' and singertype_id={1}",
                type,Convert.ToInt32(this.lvContry.SelectedItems[0].Tag));
                cmd=new SqlCommand(sql,con.Conntion);
                try
                {
                    con.OpenConntion();
                    //imageList3.Images.Clear();
                    SqlDataReader reader = cmd.ExecuteReader();
                    if (this.lvSinger.Items!=null)
                    {
                        lvSinger.Items.Clear();
                    }
                    if (reader.HasRows)
                    {
                        int index = 0;
                        while (reader.Read())
                        {
                            ListViewItem item = new ListViewItem();
                            item.Text = reader[1].ToString();
                            item.Tag = reader[0].ToString();
                            this.imageList3.Images.Add(Image.FromFile(@"E:KTVsingerPhoto" + reader[2].ToString()));
                            item.ImageIndex = index;
                            this.lvSinger.Items.Add(item);
                            index++;
                        }
                    }
                    reader.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally {
                    con.CloseConntion();
                }
            }
        }

104 第三部:  查找到该地区的歌手的歌曲

   private void lvContry_DoubleClick(object sender, EventArgs e)
        {
            DoubleClicklvSinger();
        }        private void DoubleClickSong() 
        {
            if (this.lvSinger.SelectedItems[0]!=null)
            {
                 string sql = string.Format("select song_id,song_name,song_url,singer_name from song_info,singer_info"+
                " where song_info.singer_id=singer_info.singer_id and singer_info.singer_id={0}",Convert.ToInt32(this.lvSinger.SelectedItems[0].Tag));
                 FrmSong fs = new FrmSong();
                 fs.sql = sql;

                 fs.Show();
                 this.Hide();
            }

第四部:   选中歌手信息数据库连接↓

  private void FrmSong_Load(object sender, EventArgs e)
        {
           
            adapter = new SqlDataAdapter(sql, db.Conntion);
            adapter.Fill(ds, "song_info");
      
            this.dataGridView1.DataSource = ds.Tables["song_info"];
            this.dataGridView1.AutoGenerateColumns = false;

 

以点歌曲传惨的列表

 public string Name { get; set; }
        public string age { get; set; }
        private void BOFANG_Load(object sender, EventArgs e)
        {
            this.listView1.Items.Clear();
            foreach (Song item in ListSong.list)
            {
                ListViewItem lvitem = new ListViewItem(item.SongName);
                lvitem.SubItems.Add(item.SongPath);
                string sate = item.Sate == Sateze.unPaly ? "未播放" : "已播放";
                lvitem.SubItems.Add(sate);
                this.listView1.Items.Add(lvitem);

播放音乐原理图

第五部:  if 判定DATA 窗体传惨
传送到以点歌曲中
private void dataGridView1_DoubleClick(object sender, EventArgs e)
        {
            if (this.dataGridView1.SelectedRows[0] != null)
            {
                BOFANG dd = new BOFANG();
                Song song = new Song();
                song.SongName = this.dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
                song.SongPath = this.dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
                dd.Name = song.SongName;
                ListSong.AddSong(song);
                
                MessageBox.Show("添加成功,请在已点歌曲中查看!!!");




第六步:拼音点歌
 
private void button1_Click(object sender, EventArgs e)
        {
            string en = textBox1.Text;
            SqlConnection con = new SqlConnection(Sql.str);
            string sql =string.Format( "select * from song_info where  song_ab like '"+en+"%'");
         SqlDataAdapter da = new SqlDataAdapter(sql,con);
            DataSet ds = new DataSet();

            da.Fill(ds, "song_info");

            dataGridView1.DataSource = ds.Tables["song_info"];
            SqlCommand cmd = new SqlCommand(sql,con);
            try
            {
                con.Open();
                int count = cmd.ExecuteNonQuery();
                if (count > 0)
                {
                    MessageBox.Show("查找成功");
                }
              
            }
            catch (Exception)
            {

                MessageBox.Show("网络异常请检查网络或者SQL 数据库!!!");
                con.Close();

---恢复内容结束---