default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
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.OleDb;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //if(!IsPostBack)
        //{
        //    string FileSource="C:\\excel\\usersdb.xls";
        //    string StyleSheet = "Sheet1";
        //    LoadData(FileSource,StyleSheet);
        //}
    }
    public void LoadData(string StyleSheet)
    {

        string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("usersdb.xls") + ";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();
        string strConn = "Data Source=(local);DataBase=mrdb;Uid=sa;Pwd=";
        SqlConnection conn = new SqlConnection(strConn);
        

        for (int j = 0; j < DT.Rows.Count; j++)
        {
           conn.Open();
           SqlCommand mycom = new SqlCommand("select count (*) from Userdb where UserID=" + Convert.ToInt32(DT.Rows[j][0].ToString()) + "", conn);
            int count = Convert.ToInt32(mycom.ExecuteScalar());
            if (count > 0)
            {
                Response.Write("<script>alert('对不起！您已经转换了相同的数据！')</script>");
            }
            else
            {

                string UserID = DT.Rows[j][0].ToString();
                string EmailAddress = DT.Rows[j][1].ToString();
                string FirstName = DT.Rows[j][2].ToString();
                string LastName = DT.Rows[j][3].ToString();
                string Address1 = DT.Rows[j][4].ToString();
                string Address2 = DT.Rows[j][5].ToString();
                string City = DT.Rows[j][6].ToString();
                string strSql = "insert   into   Userdb(UserID,EmailAddress,FirstName,LastName,Address1,Address2,City)   ";
                strSql = strSql + "values('" + UserID + "','" + EmailAddress + "','" + FirstName + "','" + LastName + "','" + Address1 + "','" + Address2 + "','" + City + "')";
                SqlCommand comm = new SqlCommand(strSql, conn);
                comm.ExecuteNonQuery();
                if (j == DT.Rows.Count - 1)
                {
                    Label1.Visible = true;
                }
                else
                {
                    Label1.Visible = false;
                }
            }
            conn.Close();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string StyleSheet = "Sheet1";
        LoadData(StyleSheet);
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strConn = "Data Source=(local);DataBase=mrdb;Uid=sa;Pwd=";
        string sqlstr = "select * from Userdb";
        SqlConnection conn = new SqlConnection(strConn);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr,conn);
        DataSet ds = new DataSet(); 
        conn.Open();
        myda.Fill(ds, "Userdb");
        GridView1.DataSource = ds;
        GridView1.DataBind();
        conn.Close();

    }
}