?? 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();
try
{
objAdapter1.Fill(objDataset1, "XLData");
}
finally
{
// Clean up objects.
objConn.Close();
}
// Bind data to DataGrid control.
DataGrid1.DataSource = objDataset1.Tables[0].DefaultView;
DataGrid1.DataBind();
}
}
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 + -