testrecord.cs

在线考试系统

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace Test.GlobalLibrary
{
    public class TestRecord
    {
        public void Sel(string TID,string CID)
        {
            sql sel = new sql();
            DataSet ds = new DataSet();
            string str = "select StudentID,StudentName from tblStudent where ClassID='" + CID + "'";
            ds = sel.Select(str, "tblStudent");
            Input(ds, TID);

        }

        public void Input(DataSet ds, string TestID)
        {
            sql InQues = new sql();
            string StuNum = null;
            string StuName = null;
            string SqlStr = null;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                StuNum = ds.Tables[0].Rows[i][0].ToString();
                StuName = ds.Tables[0].Rows[i][1].ToString();
                SqlStr = "insert into tblTestRecord (StudentID,StudentName,TestID) values('" + StuNum + "','" + StuName + "','" + TestID + "')";
                InQues.InDeMo(SqlStr);
            }
        }
    }
}