在vs2008中导出为ex​​cel [英] export to excel in vs2008

问题描述

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 Telerik.Web.UI;
using System.IO;
using System.Data.SqlClient;
using System.Text;
using RKLib.ExportData;

public partial class Ekomaster : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

protected void rbtnExport_Click(object sender, EventArgs e)

DataSet ds = DataAccessLayer.BindDataQuery（选择SiteID，RxDate，Alarms，CommStatus，RoomTemp，AC15EBKWH作为LoadKWH，AC15EBTIME作为LoadRunhours，AC15VR作为LoadVoltage，AC15IR作为LoadCurrent， AC15PF_R为LoadPF，AC15FREQ为负载频率，DC1CH1为SolarKWH，DC1Cur1为AS太阳能电流，DC1V为太阳能电压，DC3CH1为负载电池充电KWH，DC3 CUR1如LoadBatteryChargingCurrent，DC3CH2如LoadBatteryDischargingKWH，DC3Cur2 AS LoadBatteryDischargingCurrent，DC3Volt如LoadBatteryVoltage，DC4CH1如BB1ChargingKWH，DC4Cur1 AS BB1ChargingCurrent，DC4CH2如BB1DisChargingKWH，DC4Cur2 AS BB1DischargingCurrent，DC4Volt如BB1Voltage，PacketType，SrDate从tblSitesData1 WHERE SITEID =' + rcbExportSite.SelectedValue +'AND RxDate> ='+ FromDate +'和RxDate< '+ ToDate +'按RxDate DESC排序）;

if（ds.Tables [0] .Rows.Count> 0）

{

Response.Clear（）;

ExportExcel export = new ExportExcel（）;

GridView gvExport = new GridView（）;

gvExport.DataSource = ds;

gvExport.DataBind（）;

export.exportGrid（gvExport）;

gvExport.Dispose（）;

}

}

}







我得到了一个错误的解决方案。解决方案是什么。

DataSet ds = DataAccessLayer.BindDataQuery("select SiteID,RxDate,Alarms,CommStatus,RoomTemp,AC15EBKWH as LoadKWH,AC15EBTIME AS LoadRunhours,AC15VR as LoadVoltage,AC15IR as LoadCurrent,AC15PF_R as LoadPF,AC15FREQ as LoadFrequency,DC1CH1 as SolarKWH,DC1Cur1 AS SolarCurrent,DC1Volt as SolarVoltage,DC3CH1 as LoadbatterychargingKWH,DC3Cur1 as LoadBatteryChargingCurrent,DC3CH2 as LoadBatteryDischargingKWH,DC3Cur2 AS LoadBatteryDischargingCurrent,DC3Volt as LoadBatteryVoltage,DC4CH1 as BB1ChargingKWH,DC4Cur1 AS BB1ChargingCurrent,DC4CH2 as BB1DisChargingKWH,DC4Cur2 AS BB1DischargingCurrent,DC4Volt as BB1Voltage,PacketType,SrDate from tblSitesData1 WHERE SiteID='" + rcbExportSite.SelectedValue + "' AND RxDate >= '" + FromDate + "' AND RxDate < '" + ToDate + "' Order by RxDate DESC ");
if (ds.Tables[0].Rows.Count > 0)
{
Response.Clear();
ExportExcel export = new ExportExcel();
GridView gvExport = new GridView();
gvExport.DataSource = ds;
gvExport.DataBind();
export.exportGrid(gvExport);
gvExport.Dispose();
}
}
}



I am getting the fallowing error.what is the solution.

Error   2   The type or namespace name 'ExportExcel' could not be found (are you missing a using directive or an assembly reference?)   E:\WORKINGFOLDER\ECOSUN\Ekomaster.master.cs 58  46  E:\WORKINGFOLDER\ECOSUN\

推荐答案

好像你没有把你的DLL放到BIN文件夹中，所以首先你需要这样做。

如果第一个条件不起作用，你还需要在Web.Config中注册这个DLL。

It seems like you didn't put your DLL into the BIN folder, so first you need to do that.
also you need to register this DLL in Web.Config if the first condition does not work.

这篇关于在vs2008中导出为ex​​cel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！