cmyinfo_view.aspx.cs

简单的Web平台。能够读取Excel文件

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

public partial class CmyInfo_View : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if ( !Page.IsPostBack )
        {
            DBConnector dbConn = new DBConnector();

            string strSQL_CmpType = "SELECT ID,类型名称 FROM companyType";
            DataSet dsCmpType = dbConn.Query( strSQL_CmpType );

            ddlCmyType.DataSource = dsCmpType;
            ddlCmyType.DataTextField = "类型名称";
            ddlCmyType.DataValueField = "ID";

            ddlCmyType.DataBind();
        }
    }

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string strSQL_Inst = "INSERT INTO companyInfo 公司名称,类型编号,地址,邮政编码,联系人,联系电话,备注 "  + 
                             "VALUES @CmyName, @CmyType, @CmyAddr, @CmyPstCode, @Connector, @Phone, @Remark";

        DBConnector dbConn = new DBConnector();
        SqlCommand sqlComm = new SqlCommand( strSQL_Inst );

        sqlComm.Parameters.Add(new SqlParameter("@CmyName", SqlDbType.VarChar, 50));
        sqlComm.Parameters.Add(new SqlParameter("@CmyType", SqlDbType.Int));
        sqlComm.Parameters.Add(new SqlParameter("@CmyAddr", SqlDbType.VarChar, 100));
        sqlComm.Parameters.Add(new SqlParameter("@CmyPstCode", SqlDbType.VarChar, 10));
        sqlComm.Parameters.Add(new SqlParameter("@Connector", SqlDbType.VarChar, 20));
        sqlComm.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 20));
        sqlComm.Parameters.Add(new SqlParameter("@Remark", SqlDbType.VarChar, 200));

        sqlComm.Parameters["@CmyName"].Value = txtCmyName.Text;
        sqlComm.Parameters["@CmyType"].Value = ddlCmyType.SelectedValue;
        sqlComm.Parameters["@CmyAddr"].Value = txtCmyAddr.Text;
        sqlComm.Parameters["@CmyPstCode"].Value = txtCmyPostCode.Text;
        sqlComm.Parameters["@Connector"].Value = txtCmyCtcName.Text;
        sqlComm.Parameters["@Phone"].Value = txtCmyCtcPhone.Text;
        sqlComm.Parameters["@Remark"].Value = txtCmyRemark.Text;

        int iEffectRow = dbConn.Execute( sqlComm );
    }
}