예제 #1
0
파일: Form1.cs 프로젝트: gaojundz/ClassSys
        public void ReadAllSct()
        {
            //------------------------------------------------------------------------------------
            listView5.BeginUpdate();
            listView5.Items.Clear();

            //读取整张表
            SQLiteDataReader reader = sql.ReadFullTable("sct");

            while (reader.Read())
            {
                int no = listView5.Items.Count;
                listView5.Items.Add(Convert.ToString(no + 1));
                listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("GUID")));
                listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("sno")));
                listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("cno")));
                listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("tno")));
                listView5.Items[no].SubItems.Add(reader.GetString(reader.GetOrdinal("grade")));
            }
            //-------------------------------------------------------------------------------
            listView5.EndUpdate();
        }