我的程序员行程

2008-12-2日c#窗体：今天做了很久的鼠标悬浮事件，结果明白应该是移动事件，不过去鼠标坐标的这个用法还将就。


        Point position = Point.Empty;
  

        private void lsBFilter_MouseMove(object sender, MouseEventArgs e)
        {
            position = new Point(e.X, e.Y);
             int i = 0;

             for (i = lsBFilter.Items.Count - 1; i > 0; i--)
             {
                 if (position.Y >= i * lsBFilter.ItemHeight)
                 {
                     lsBFilter.SetSelected(i, true);
                     break;
                 }
                 if (position.Y < lsBFilter.ItemHeight)
                 {
                     lsBFilter.SetSelected(0, true);
                 }

             }
        }

        private void txtBookName_MouseClick(object sender, MouseEventArgs e)
        {
            lsBFilter.ClearSelected();
            lsBFilter.Visible = false;
        }


  第一次使用文本框和listbox实现方便的数据库查询

private void txtBookName_TextChanged(object sender, EventArgs e)
        {
            cboBook.SelectedIndex = -1;
            cboClass.SelectedIndex = -1;
            cboUsers.SelectedIndex = -1;
            lsBFilter.Items.Clear();
            if (txtBookName.Text.Trim() != "")
            {
                strSql = string.Format("select DISTINCT Booksname from BookInfo where Booksname like '%{0}%'", txtBookName.Text.Trim());

                DBHelper.getDataTableA(strSql);
                int i = 0;
             
                while (DBHelper.NumF.Length > 0 && i < DBHelper.NumF.Length)
                {
                    lsBFilter.Items.Add(DBHelper.NumF[i]);
                    i++;
                }
                if (DBHelper.NumF.Length > 0)
                {
                    lsBFilter.SetBounds(txtBookName.Location.X, txtBookName.Location.Y + txtBookName.Height, txtBookName.Width, 4 * txtBookName.Height);
                    lsBFilter.ScrollAlwaysVisible = false;
                    lsBFilter.Visible = true;
                }
                lsBFilter.SetSelected(0, true);
            }
            if (txtBookName.Text.Trim() == "")
            {
                lsBFilter.Items.Clear();
                lsBFilter.Visible = false;
            }
        }