Example #1
0
        public void Favourates_Load(object sender, EventArgs e)
        {
            string sql1 = "select count(*) from MyWordsNote";

            for (long i = 1; i <= long.Parse(AccessHelper.QuerybySql(sql1)); i++)
            {
                string sql_words = "select English from MyWordsNote where ID = " + i;
                string sql_means = "select Chinese from MyWordsNote where ID = " + i;
                string sql_note  = "select Note from MyWordsNote where ID = " + i;
                textBox1.Text += AccessHelper.QuerybySql(sql_words) + "    " + AccessHelper.QuerybySql(sql_means) + "    " + AccessHelper.QuerybySql(sql_note) + "\r\n";
            }
        }