?? excelreader.ascx
字號:
<%@ Control language="c#" Inherits="Rainbow.DesktopModules.OneFileModule" %><%@ Register TagPrefix="cc1" Namespace="Rainbow.UI.WebControls" Assembly="Rainbow" %><script language="C#" runat="server"> public override Guid GuidID { get { return new Guid("{1E03D793-5A01-4f35-811D-5D23EF66618D}"); } } void Page_Load(Object sender, EventArgs e) { try { // get the settings for this module InitSettings(SettingsType.Str); if (SettingsExists) { // Settings are : ExcelFile + RangeName // pick the Excel file from settings adding the path from the portal Data directory Rainbow.UI.DataTypes.PortalUrlDataType pt; pt = new Rainbow.UI.DataTypes.PortalUrlDataType(); pt.Value = GetSetting("ExcelFile"); String sExcelFile = Server.MapPath(Rainbow.Configuration.PortalSettings.SolutionPath + "/" + pt.FullPath); // Create connection String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + sExcelFile + ";" + "Extended Properties=Excel 8.0;"; System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(sConnectionString); objConn.Open(); // The code to follow uses a SQL SELECT command to display the data from the worksheet. System.Data.OleDb.OleDbCommand objCmdSelect =new System.Data.OleDb.OleDbCommand("SELECT * FROM " + GetSetting("RangeName"), objConn); System.Data.OleDb.OleDbDataAdapter objAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); objAdapter1.SelectCommand = objCmdSelect; // Create new DataSet to hold information from the worksheet. System.Data.DataSet objDataset1 = new System.Data.DataSet(); objAdapter1.Fill(objDataset1, "XLData"); // Bind data to DataGrid control. DataGrid1.DataSource = objDataset1.Tables[0].DefaultView; DataGrid1.DataBind(); // Clean up objects. objConn.Close(); } } catch { } }</script><cc1:DesktopModuleTitle EditText="Edit" EditUrl="~/DesktopModules/PropertyPage.aspx" PropertiesText="PROPERTIES" PropertiesUrl="~/DesktopModules/PropertyPage.aspx" runat="server" ID="ModuleTitle" /><asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -