<%@ 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>