datagirdviewºÍlistview,ɾ¸Ä²ésqlserverÊý¾Ý¿âµÄС½á

        //´´½¨DBhelperÊý¾Ý¿âÁ´½ÓÎļþ
        private static string sqlcon = "server=.;database=myschool;uid=sa;pwd=sa";
        public static SqlConnection connection = new SqlConnection(sqlcon);
============================================================
            //Ê×ÏÈÊÇlv¿Ø¼þµÄÁбíÏÔʾ ,(listview)
            // Çå¿Õµ±Ç°lv±íÖÐÄÚÈÝ
            listview.Items.Clear();
            string sql = "select * from question";
            //ÒýÓÃDBhelperÖеÄÊý¾Ý¿âÁ´½Ó
            SqlCommand command = new SqlCommand(sql,DBhelper.connection);
            //´ò¿ªÊý¾Ý¿â,²¢ÓÃdr¶ÁÈ¡¼Ç¼
            DBhelper.connection.Open();
            SqlDataReader dr = command.ExecuteReader();
            while (dr.Read())
            {
                ListViewItem lvi = new ListViewItem(dr["Question"].ToString());
                lvi.SubItems.AddRange(new string[] { dr["Answer"].ToString(), dr["Difficulty"].ToString(), dr["SubjectId"].ToString(), dr["OptionA"].ToString(), dr["OptionB"].ToString(), dr["OptionC"].ToString(), dr["OptionD"].ToString() });