admin/DataInput.aspx.cs

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

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

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

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

    }
    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 where Id=" + Convert.ToInt32(DT.Rows[j][0].ToString()) + "", con);
            int count = Convert.ToInt32(mycom.ExecuteScalar());
            if (count > 0)
            {
                Response.Write("<script>alert('对不起！您已经转换了相同的数据！')</script>");
            }
            else
            {
                string sstr1 = Session["drop1"].ToString();
                string sstr2 = Session["drop2"].ToString();
                string sstr3 = Session["drop3"].ToString();

                string Id = DT.Rows[j][0].ToString();
                string que_subject = DT.Rows[j][1].ToString();
                string que_type = DT.Rows[j][2].ToString();
                string que_joindate = DT.Rows[j][3].ToString();
                string que_Lessonid = DT.Rows[j][4].ToString();
                string que_profession = DT.Rows[j][5].ToString();
                string que_taotiid = DT.Rows[j][6].ToString();