public enum SongPlayState
 {
  //未播放，播放，重播，切歌
  unplayed, played, again, cut
 }
 public class Song
 {
  public string SongName { get; set; }//歌曲名称
  public string SongURL { get; set; }//歌曲路径
  public SongPlayState playState = SongPlayState.unplayed;//默认未播放
  internal SongPlayState PlayState { get; set; }
  //状态为已播
  public void SetSongPlayed()
  {
  this.PlayState = SongPlayState.played;
  }
  //重唱
  public void SetPlayAgain()
  {
  this.playState = SongPlayState.again;
  }
  //切歌
  public void SetSongCut()
  {
  this.playState = SongPlayState.cut;
  }

 public class PlayList
 {
  //定义一个长度为、 的歌曲数组，默认存储 首歌曲
  public static Song[] SongList = new Song[ ];
  public static int SongIndex = ;//当前播放的歌曲在数组中的索引
  //点播一首歌曲，其实是将歌曲对象添加到歌曲数组中
  public static bool AddSong(Song song)
  {
  bool success = false;//记录添加歌曲是否成功
  for (int i = ; i < SongList.Length; i++)
  {
   //找到数组中第一个为null的位置
   if (SongList[i] == null)
   {
   SongList[i] = song;
   success = true;
   break;
   }
  }
  return success;
  }
  //获取当前播放的歌曲：：既然是获取当前播放的歌曲，返回值肯定是Song类型
  public static Song GetPlaySong()
  {
  if (SongList[SongIndex] != null)
  {
   return SongList[SongIndex];
  }
  else
  {
   return null;
  }
  }
  /// <summary>
  /// 播放下一首
  /// </summary>
  public static void MoveOn()
  {
  if (SongList[SongIndex] != null && SongList[SongIndex].PlayState == SongPlayState.again)
  {
   SongList[SongIndex].SetSongPlayed();
  }
  else
  {
   SongIndex++;
  }
  }
  /// <summary>
  /// 当前播放的歌曲名称
  /// </summary>
  /// <returns>歌曲名称</returns>
  public static string PlayingSongName()
  {
  string songName = \"\"; // 歌曲名称
  if (SongList[SongIndex] != null)
  {
   songName = SongList[SongIndex].SongName;
  }
   return songName;
  }
  /// <summary>
  /// 下一首要播放的歌曲名称
  /// </summary>
  /// <returns>歌曲名称</returns>
  public static string NextSongName()
  {
  string songName = \"\"; // 歌曲名称
  if (SongList[SongIndex + ] != null)
  {
   songName = SongList[SongIndex + ].SongName;
  }
   return songName;
  }
  //重放当前歌曲
  public static void PlayAgain()
  {
  if (SongList[SongIndex] != null)
  {
   SongList[SongIndex].SetPlayAgain();
  }
  }
  //切歌
  public static void CutSong(int index)
  {
  int i;//循环变量，代表切歌的位置
  if (index == - )//循环变量，代表切割的位置
  {
   i = SongIndex;
  }
  else
  {
   i = index;//从切歌的位置开始，将歌曲逐个向前移一个位置
  }
  SongList[i].SetSongCut();
  while (SongList[i] != null)
  {
   SongList[i] = SongList[i + ];
   i++; 
   //如果达到数组最后一个元素，就将最后一个元素指向空
   if (i == SongList.Length)
   {
   SongList[i] = null;
   }
  }
  }
 }

 public FrmMain frmMain;
  string connectionStr = \"server=.;database=MyKTV;uid=sa\";
  DBHelp db = new DBHelp();
  private SqlConnection con;
  //首先要查出数据库中的图片路径和歌曲路径
  private void FrmCountry_Load(object sender, EventArgs e)
  {
   con = new SqlConnection(connectionStr);
  con.Open();
  string sql = \"select resource_path from resource_path where resource_id= \";
   string sqlsongpath = \"select resource_path from resource_path where resource_id= \";
  SqlCommand cmd = new SqlCommand(sql,con);
   SqlCommand cmd = new SqlCommand(sqlsongpath, con);
  KtvUnit.ImagePath = cmd.ExecuteScalar().ToString();
  KtvUnit.SongPath = cmd .ExecuteScalar().ToString();
  con.Close();
  }
  //点击歌手男女或组合时
  private void LvOne_Click(object sender, EventArgs e)
  {
   LoadSingerArea();
  }
  public string singer_type { get; set; }
  private void LoadSingerArea()
  {
  if (this.LvOne.SelectedItems[ ] != null)
  {
   LvOne.Visible = false;
   LvTwo.Location = LvOne.Location;
   LvTwo.Dock = DockStyle.Fill;
   LvTwo.Visible = true;
   this.singer_type=Convert.ToString(LvOne.SelectedItems[ ].Text);
  }
   con = new SqlConnection(connectionStr);
  string sql = \"select singertype_id,singertype_name from singer_type\";
  SqlCommand cmd = new SqlCommand(sql, con);
  SqlDataReader dr;
  try
  {
   con.Open();
   LvTwo.Items.Clear();
   dr = cmd.ExecuteReader();  
   if (dr.HasRows)
   {
   int index = ;
   while (dr.Read())
   {
    ListViewItem lvItem = new ListViewItem();
    int typeid = Convert.ToInt (dr[\"singertype_id\"]);
    string typename = Convert.ToString(dr[\"singertype_name\"]);
    lvItem.Text = typename;
    lvItem.Tag = typeid;
    lvItem.ImageIndex = index;
    LvTwo.Items.Add(lvItem);
    index++;
   }
   }
   dr.Close();
  }
  catch (Exception ex)
  {
   MessageBox.Show(\"系统出现异常\" + ex.Message);
  }
  finally 
  {
   con.Close();
  }
  }
  public string singertype_id { get; set; }
  /// <summary>
  /// 点击地区类型时
  /// </summary>
  /// <param name=\"sender\"></param>
  /// <param name=\"e\"></param>
  private void LvTwo_Click(object sender, EventArgs e)
  {
  if (this.LvTwo.SelectedItems[ ] != null)
  {
   LvTwo.Visible = false;
   Lvthree.Location = LvTwo.Location;
   Lvthree.Dock = DockStyle.Fill;
   Lvthree.Visible = true;
   this.singertype_id = Convert.ToString(LvTwo.SelectedItems[ ].Tag);
  }
  string result = singer_type;
  if (result != \"组合\")
  {
   result = singer_type == \"女歌手\" ? \"女\" : \"男\";
  }
  con = new SqlConnection(connectionStr);
  string sql =string.Format( \"select singer_id,singer_name,singer_photo_url from singer_info where singertype_id={ } and singer_Sex=\'{ }\'\",singertype_id,result);
  SqlCommand cmd = new SqlCommand(sql, con);
  SqlDataReader dr;
  try
  {
   con.Open();
   int index = ;
   Lvthree.Items.Clear();
   imageList .Images.Clear();
   dr = cmd.ExecuteReader();
   if (dr.HasRows)
   { 
   while (dr.Read())
   {   
    string photoURL =KtvUnit.ImagePath + Convert.ToString(dr[\"singer_photo_url\"]);
    //先给ImageList填充图片
    imageList .Images.Add(Image.FromFile(photoURL));
    ListViewItem lvItem = new ListViewItem();
    lvItem.Text = Convert.ToString(dr[\"singer_name\"]);
    lvItem.Tag = Convert.ToString(dr[\"singer_id\"]);
    lvItem.ImageIndex = index;
    Lvthree.Items.Add(lvItem);
    index++;
   }
   }
   dr.Close();
  }
  catch (Exception ex)
  {
   MessageBox.Show(\"系统出现异常\" + ex.Message);
  }
  finally
  {
   con.Close();
  }
  }
  public void SongList()
  {
  //读取数据库，读出该歌手的所有歌曲
   StringBuilder sb = new StringBuilder();
  //拼接SQL语句
  sb.AppendFormat(\"select song_id,song_name,song_url,singer_name from song_info,singer_info where singer_name=\'{ }\' and song_info.singer_id={ }\", Lvthree.SelectedItems[ ].Text, Convert.ToInt (Lvthree.SelectedItems[ ].Tag));
  FrmSongList songList = new FrmSongList();
   songList.Sql = sb.ToString();
  songList.Previous = KtvClient.PrevioisForm.Singer;//指定返回的窗体是按歌手点歌
  songList.ShowDialog();
  this.Close();
  }
  private void Lvthree_Click(object sender, EventArgs e)
  {
  SongList();
  }
  private void tsSingerMain_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Show();
  this.Hide();
  }
  private void tsSingerBack_Click(object sender, EventArgs e)
  {
  if (this.LvOne.Visible==true)
  {
   FrmMain man = new FrmMain();
   man.Show();
   this.Hide();
  }
  else if (this.LvTwo.Visible==true)
  {
   this.LvTwo.Visible = false;
   this.LvOne.Visible = true;
  }
  else if (this.Lvthree.Visible==true)
  {
   this.Lvthree.Visible = false;
   this.LvTwo.Visible = true;
  }
  }
  private void tsSingerCut_Click(object sender, EventArgs e)
  {
  PlayList.CutSong(- );
  }
  private void tsSingerAgain_Click(object sender, EventArgs e)
  {
  PlayList.PlayAgain();
  }
  private void tsSingerYidian_Click(object sender, EventArgs e)
  {
  FrmPlayList frm = new FrmPlayList();
  frm.Show();
  }

 public FrmMain frmMain;
  [DllImportAttribute(\"user .dll\")]
  private static extern bool AnimateWindow(IntPtr hwnd, int dwTime, int dwFlags);
  DBHelp db = new DBHelp();
  string connectionStr = \"server=.;database=MyKTV;uid=sa\";
  private void FrmPinYin_Load(object sender, EventArgs e)
  {
  AnimateWindow(this.Handle, , FrmMain.AW_SLIDE + FrmMain.AW_VER_POSITIVE);
  SqlConnection con = new SqlConnection(connectionStr);
  con.Open();
  db.connection(); 
  string sqlsongpath = \"select resource_path from resource_path where resource_id= \";
  SqlCommand cmd = new SqlCommand(sqlsongpath, con);
  KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
  }
  private void btnSearch_Click(object sender, EventArgs e)
  {
  string PinYin = this.txtPinYin.Text;
  //判断是否是中文 还是拼音
  if (!Regex.IsMatch(this.txtPinYin.Text, @\"^[\\u e -\\u fa ]+$\"))
  {
   StringBuilder PY = new StringBuilder(PinYin);
   for (int i = ; i <= PY.Length; i++)
   {
   PY.Insert(i, \"%\");
   i++;
   }
   string sql = string.Format(\"SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_ab LIKE \'{ }\'\", PY);
   this.dgvPinYinInfo.DataSource = db.dataTable(sql,\"PY\");
  }
  else
  {
   StringBuilder ZW = new StringBuilder(PinYin);
   for (int i = ; i < ZW.Length; i++)
   {
   ZW.Insert(i,\"%\");
   i++;
   }
   string sql = string.Format(\"SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_name LIKE \'{ }\'\", ZW);
   this.dgvPinYinInfo.DataSource = db.dataTable(sql, \"PY\");
  }
  }
  private void dgvPinYinInfo_DoubleClick(object sender, EventArgs e)
  {
  string songname = this.dgvPinYinInfo.SelectedRows[ ].Cells[\"song_name\"].Value.ToString();
  DBHelp db = new DBHelp();
  db.connection();
  string sql = string.Format(\"SELECT song_name,singer_name,song_url,song_photo_url FROM dbo.song_info,dbo.singer_info where dbo.singer_info.singer_id=dbo.song_info.singer_id and song_name=\'{ }\'\",songname);
   SqlDataReader reader = db.ExecuteReaders(sql.ToString());
   Song song;
  if (reader.Read())
  {
   song = new Song();
   song.SongName = reader[\"song_name\"].ToString();
   song.SongURL = KtvUnit.SongPath+reader[\"song_url\"].ToString();
   PlayList.AddSong(song);  
  }
  reader.Close();
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"a\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"b\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"c\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"d\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"e\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"f\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"g\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"h\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"i\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"j\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"k\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"l\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"m\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"n\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"o\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"p\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"q\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"r\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"s\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"t\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"u\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"v\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"w\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"x\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"y\";
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  textBox .Text = textBox .Text + \"z\";
  }
  private void FrmPinYin_FormClosing(object sender, FormClosingEventArgs e)
  {
  AnimateWindow(this.Handle, , FrmMain.AW_SLIDE + FrmMain.AW_VER_POSITIVE);
  }
  public void Binder() 
  {
  string PinYin = this.textBox .Text;
  StringBuilder PY = new StringBuilder(PinYin);
   for (int i = ; i <= PY.Length; i++)
  {
   PY.Insert(i, \"%\");
   i++;
  }
  string sql = string.Format(\"SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_ab LIKE \'{ }\'\", PY);
  DataSet ds = db.dataSet(sql, \"PY\");
  if (ds.Tables[\"PY\"]!=null)
  {
   ds.Tables[\"PY\"].Clear();
  }
  this.dgvPinYinInfo.DataSource = db.dataTable(sql, \"PY\");
  }
  private void pictureBox _Click(object sender, EventArgs e)
  {
  string text = textBox .Text;
  int index = text.Length - ;
  if (index >= )
  {
   textBox .Text = text.Remove(index);
  }
  }
  private void textBox _TextChanged(object sender, EventArgs e)
  {
  if (textBox .Text!=string.Empty)
  {
   Binder();
   this.dgvPinYinInfo.AutoGenerateColumns = false;
  }
  else
  {
   this.dgvPinYinInfo.DataSource=null;
  }
  }
  private void tsPYMain_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Show();
  this.Hide();
  }
  private void txPYAgain_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Playsong();
  }
  Song song = new Song();
  private void tsPYCut_Click(object sender, EventArgs e)
  {
  song.playState = SongPlayState.cut;
  }
  private void tsPYYidian_Click(object sender, EventArgs e)
  {
  FrmPlayList list = new FrmPlayList();
  list.Show();
  }
  private void tsPYBack_Click(object sender, EventArgs e)
  {
  Application.Exit();
  } 

 public FrmMain frmMain;
  string connectionStr = \"server=.;database=MyKTV;uid=sa\";
  DBHelp db = new DBHelp();
  private SqlConnection con;
  private void FrmSongType_Load(object sender, EventArgs e)
  {
  con = new SqlConnection(connectionStr);
  con.Open();
  string sql = \"select resource_path from resource_path where resource_id= \";
  string sqlsongpath = \"select resource_path from resource_path where resource_id= \";
  SqlCommand cmd = new SqlCommand(sqlsongpath,con);
  KtvUnit.SongPath = cmd .ExecuteScalar().ToString();
  SqlCommand cmd = new SqlCommand(sql, con);
  KtvUnit.ImagePath = cmd.ExecuteScalar().ToString();
  con.Close();
   con = new SqlConnection(connectionStr);
  string sql = string.Format(\"select songtype_id,songtype_name,songtype_URL from song_type\");
  SqlCommand cmd = new SqlCommand(sql , con);
  SqlDataReader dr;
  try
  {
   con.Open();
   int index = ;
   lvSongType.Items.Clear();
   imageList .Images.Clear();
   dr = cmd .ExecuteReader();
   if (dr.HasRows)
   {
   while (dr.Read())
   {
    string photoURL = KtvUnit.ImagePath + Convert.ToString(dr[\"songtype_URL\"]);
    //先给ImageList填充图片
    imageList .Images.Add(Image.FromFile(photoURL));
    ListViewItem lvItem = new ListViewItem();
    lvItem.Text = Convert.ToString(dr[\"songtype_name\"]);
    lvItem.Tag = Convert.ToString(dr[\"songtype_id\"]);
    lvItem.ImageIndex = index;
    lvSongType.Items.Add(lvItem);
    index++;
   }
   }
   dr.Close();
  }
  catch (Exception ex)
  {
   MessageBox.Show(\"系统出现异常\" + ex.Message);
  }
  finally
  {
   con.Close();
  }
  }
  private void LoadSongType()
  {
  //读取数据库，读出该歌曲类型的所有歌曲
   StringBuilder sb = new StringBuilder();
  //拼接SQL语句
  sb.AppendFormat(\"select song_info.song_name,singer_info.singer_name,song_info.song_url from singer_info,song_info where song_info.singer_id=singer_info.singer_id and song_info.songtype_id={ }\", Convert.ToInt (lvSongType.SelectedItems[ ].Tag));
  FrmSongList songList = new FrmSongList();
   songList.Sql = sb.ToString();
  songList.Previous = KtvClient.PrevioisForm.SongType;//指定返回的窗体是按歌曲类型点歌
  songList.ShowDialog();
  this.Close();
  }
  private void lvSongType_Click(object sender, EventArgs e)
  {
  LoadSongType();
  }
  private void tsTYSingerMain_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Show();
  this.Hide();
  }
  private void tsTYSingerAgain_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Playsong();
  }
  Song song = new Song();
  private void tsTYSingerCut_Click(object sender, EventArgs e)
  {
  song.playState = SongPlayState.cut;
  }
  private void tsTYSingerYidian_Click(object sender, EventArgs e)
  {
  FrmPlayList list = new FrmPlayList();
  list.Show();
  }
  private void tsTYSingerBack_Click(object sender, EventArgs e)
  {
  FrmMain main = new FrmMain();
  main.Show();
  this.Hide();
  }

public FrmMain frmMain;
  DBHelp db = new DBHelp();
  string connectionStr = \"server=.;database=MyKTV;uid=sa\";
  private void FrmJB_Load(object sender, EventArgs e)
  {
  SqlConnection con = new SqlConnection(connectionStr);
  con.Open();
  db.connection();
  string sql = \"SELECT song_name,song_play_count FROM dbo.song_info ORDER BY song_play_count DESC\";
  string sqlsongpath = \"select resource_path from resource_path where resource_id= \";
  SqlCommand cmd = new SqlCommand(sqlsongpath, con);
  KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
  DataSet ds = db.dataSet(sql,\"Count\");
  this.dgvSongList.DataSource = ds.Tables[\"Count\"].DefaultView;
  }
  private void dgvSongList_Click(object sender, EventArgs e)
  {
  DBHelp db = new DBHelp();
  if (dgvSongList.SelectedRows[ ]!=null)
  {
   string songname = this.dgvSongList.SelectedRows[ ].Cells[\"SongName\"].Value.ToString();
   db.connection();
   string sql = string.Format(\"SELECT song_name,singer_name,song_url,song_photo_url FROM dbo.song_info,dbo.singer_info where dbo.singer_info.singer_id=dbo.song_info.singer_id and song_name=\'{ }\'\", songname);
   SqlDataReader reader = db.ExecuteReaders(sql.ToString());
   Song song;
   if (reader.Read())
   {
   song = new Song();
   song.SongName = reader[\"song_name\"].ToString();
   song.SongURL = KtvUnit.SongPath + reader[\"song_url\"].ToString();
   PlayList.AddSong(song);
   }
   reader.Close();
  }
  else
  {
   MessageBox.Show(\"空\");
  }
  }
 

 public FrmMain frmMain;
  string connectionStr = \"server=.;database=MyKTV;uid=sa\";
  DBHelp db = new DBHelp();
  private SqlConnection con;
  private void FrmNumber_Load(object sender, EventArgs e)
  {
  con = new SqlConnection(connectionStr);
  con.Open();
  string sqlsongpath = \"select resource_path from resource_path where resource_id= \";
  SqlCommand cmd = new SqlCommand(sqlsongpath, con);
  KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
  con.Close();
  for (int i = ; i <= ; i++)
  {
   for (int j = ; j <= ; j++)
   {
   Label label = new Label();
   label.ForeColor = Color.Red;
   label.BackColor = Color.Pink;
   label.Font=new System.Drawing.Font(\"华文彩云\", );
   label.TextAlign = ContentAlignment.MiddleCenter;
   label.Click += label_Click;
   this.MouseMove += FrmNumber_MouseMove;
   label.MouseHover += label_MouseHover;
   label.Size = new System.Drawing.Size( , );
   label.Text = j.ToString();
   if (i > )
   {
    label.Text = (j + i + ).ToString();
   }
   if (i > )
   {
    label.Text = (j + i + ).ToString();
   }
   if (i > )
   {
    label.Text = (j + i + ).ToString();
   }     
   label.Location = new Point( + * j, + * i);
   this.Controls.Add(label);
   }
  }
  }

 private void FrmPlayList_Load(object sender, EventArgs e)
  {
  SongList();
  }
  public void SongList() 
  {
  lvSong.Items.Clear();
  for (int i = ; i < PlayList.SongList.Length; i++)
  {
   if (PlayList.SongList[i]!=null)
   {
   ListViewItem item = new ListViewItem();
   item.Text = PlayList.SongList[i].SongName;
   item.Tag = i;
   string playstate = PlayList.SongList[i].PlayState == SongPlayState.unplayed ? \"未播放\" : \"已播\";
   item.SubItems.Add(playstate);
   lvSong.Items.Add(item);
   }
  }
  }
  private void btnClose_Click(object sender, EventArgs e)
  {
  this.Close();
  }