admin/Startexam.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Data.OleDb;

public partial class QianUser_StartExamfra : System.Web.UI.Page
{
    DataCode dataconn = new DataCode();
    protected void Page_Load(object sender, EventArgs e)
    {

        ST_check_Login();
    }
    public void ST_check_Login()
    {
        //打开数据库连接，并调用公共类中的getcon方法
        SqlConnection con = dataconn.getcon();
        con.Open();
        // string sqlstr1 = "select count(*) from tb_StuResult where stu_id ='" + Session["StuName"] + "'";
        string sqlstr1 = "select count(*) from tb_Questions where que_lessonid='" + Session["drop1"].ToString() + "'and que_professionid ='" + Session["drop2"].ToString() + "'and que_taotiid ='" + Session["drop3"].ToString() + "'";
        SqlCommand mycom = new SqlCommand(sqlstr1, con);
        int intcount = Convert.ToInt32(mycom.ExecuteScalar());
        if (intcount > 0)
        {
            Response.Write("<script>alert('对不起！您已经转换了相同的数据！！');location='insert_taoti.aspx'</script>");
        }
    }
    public void LoadData(string StyleSheet)
    {
        string strPath = ("c:\\test\\" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
        File1.PostedFile.SaveAs(strPath);
        string strCon = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + strPath + "';Extended Properties=Excel 8.0";
        OleDbConnection myConn = new OleDbConnection(strCon);
        myConn.Open();   //打开数据链接，得到一个数据集     
        DataSet myDataSet = new DataSet();   //创建DataSet对象     
        string StrSql = "SELECT * FROM [" + StyleSheet + "$]";
        OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
        myCommand.Fill(myDataSet, "[" + StyleSheet + "$]");
        myCommand.Dispose();
        DataTable DT = myDataSet.Tables["[" + StyleSheet + "$]"];
        myConn.Close();
        myCommand.Dispose();
        SqlConnection con = dataconn.getcon();
        for (int j = 0; j < DT.Rows.Count; j++)
        {
            con.Open();
            SqlCommand mycom = new SqlCommand("select count (*) from tb_Questions ", con);
            int count = Convert.ToInt32(mycom.ExecuteScalar());
            //if (count > 0)
            //{
            //    Response.Write("<script>alert('对不起！您已经转换了相同的数据！')</script>");