m8s00

DropDownList ddl = New DataTable();
DataTable dt = New DataTable();
string sql = null;

sql = "SELECT COL1, COL2, COL3 FROM DUAL";

dt = SelectCommand(sql); //Run SQL

ddl.DataSource = dt;
ddl.DataValueField = "COL1";

m8s00

DataTable dt = New DataTable();
dt.Columns.Add("COL1");
dt.Columns.Add("COL2", typeof(int), "Convert(COL1,'System.Int32')");

m8s00

using (XLWorkbook book = new XLWorkbook(XLEventTracking.Disabled))
{
  //IXLWorksheet sheet = book.AddWorksheet("1");
  IXLWorksheet sheet = book.Worksheets.Add("1");
  sheet.Range("A1").Value = "test";
  // ﾌｧｲﾙﾀﾞｳﾝﾛｰﾄﾞ
  HttpResponse response = Page.Response;
  // ﾚｽﾎﾟﾝｽ情報を初期化
  response.Clear();
  // ｺﾝﾃﾝﾄﾀｲﾌﾟにXML形式を設定

m8s00

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="oracle.manageddataaccess.client"
      type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
    </configSections>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
    </startup>
    <system.data>