DataSource of GridView is Excel

前台:

   <div>
            <table style="border-right: medium none; border-top: medium none; border-left: medium none;
                border-bottom: medium none" class="BillTable" cellspacing="0" cellpadding="0"
                width="100%">
                <caption style="border-right: medium none; border-top: medium none; border-left: medium none;
                    border-bottom: medium none">
                    <br />
                    <asp:Label ID="kk" runat="server" Text=" 江苏公司网络部-核心网专业室员工“卓越与进步”表扬档案记录榜" Font-Bold="true"
                        Font-Size="25px"></asp:Label>
                </caption>
                <tbody>
                </tbody>
            </table>
            <asp:SGridView ID="sgvPerson" runat="server" PageSize="5" AllowPaging="true" OnPageIndexChanging="sgvPerson_PageIndexChanging">
            </asp:SGridView>
        </div>

后台:

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("http://www.cnblogs.com/AttacheFile/核心网室员工《卓越与进步》表扬档案记录榜080927.xls") + "; Extended Properties=Excel 8.0;";
            OleDbConnection objConn = new OleDbConnection(strConn);
            objConn.Open();
            OleDbCommand objCmd = new OleDbCommand("select * from [sheet1$]", objConn);
            OleDbDataAdapter objAdapter = new OleDbDataAdapter();
            objAdapter.SelectCommand = objCmd;
            DataSet ds = new DataSet();
            objAdapter.Fill(ds, "XLSData");
            sgvPerson.DataSource = ds.Tables[0].DefaultView;
            sgvPerson.DataBind();
            GridViewDS = ds;
            objConn.Close();
            sgvPerson.Columns[8].ItemStyle.Wrap = false;
            sgvPerson.Columns[2].ItemStyle.Wrap = false;
            sgvPerson.Columns[3].ItemStyle.Wrap = false;
            sgvPerson.Columns[4].ItemStyle.Wrap = false;
        }
    }

posted @ 2008-10-21 15:39  Gerald1983  阅读(171)  评论(0)    收藏  举报