摘要： Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'データ配列 Dim companies() = New Company() { _ New Company("X01", "ABC com", 34), _ New Company("X02", "DEF inc", 19), _ New Company(... 阅读全文

摘要： 1.扩展方法 （Extension Methods）给Person类扩展Print方法Public Module PersonExtension _ Public Sub Print(ByVal aPerson As Person) If aPerson IsNot Nothing Then Console.WriteLine("Istance of Person : " & aPerson.ToString()) Else Console.WriteLine("No instance of Person."... 阅读全文

摘要： 1.取消了连接符（1）","之后（2）"()"前后（3）"{}"前后（4）XML（5）连接字符"&"后（6）赋值符号"=","&=",":=","+=","-=","*=","/=","\=","^=",">="后（7）式内の二項演算子"+","-",&qu 阅读全文

摘要： 1.保持Msgbox的Icon2.可以追加Checkbox，RadioBOx下载 阅读全文

摘要： 'スクロールバーの移動FpSpread1.ShowColumn(0, 0, HorizontalPosition.Left)'SetActiveCellの後、LeaveCellを呼び出すDim ss As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbookFpSpread1_LeaveCell(FpSpread1, New FarPoint.Win.Spread.LeaveCellEventArgs(ss, rowIdx, colIdx, newRow, newCol))'行書式コピーFpSpread1. 阅读全文

摘要： ●Oracleとの接続テスト"; echo ""; for ( $i = 1; $i " . $column_name . ""; } echo ""; // データのFetch while(OCIFetch($stmt)) { echo ""; for ( $i = 1; $i " . OCIResult($stmt, $column_name) . ""; } echo ""; } echo ""; // リソースの解放 阅读全文

摘要： 按行显示的合计select game, sum(purchase) as purchase_sum from purchase group by game;按列显示的合计select sum(case when game = 'action' then purchase else 0 end) as sum_action, sum(case when game = 'puzzle' then purchase else 0 end) as sum_puzzle, sum(case when gam... 阅读全文

摘要： enc = System.Text.Encoding.GetEncoding("shift-jis") datamodel = CType(FpSpread1.ActiveSheet.Models.Data, Model.DefaultSheetDataModel) Dim enc As System.Text.Encoding Dim WithEvents datamodel As Model.DefaultSheetDataModel Private Sub datamodel_Changed(ByVal sender As Object, ByVal e ... 阅读全文

摘要： ''' ''' 下矢印の動作クラス''' ''' Public Class DownArrowActionDouble ' Actionクラスを継承したサブクラスを作成します Inherits FarPoint.Win.Spread.Action Public Event FormartRow(ByVal sender As Object, ByVal e As FormatRowEventArgs) Public Event CheckRow(ByVal sender As Object, 阅读全文

摘要： Oracleの分析関数のサンプル集概要Oracleコミュニティでよく見かける分析関数の使用例を習うより慣れろ形式で、分析関数のイメージを付けて、まとめて紹介します。Oracle11gR1で動作確認しましたが、Oracle11gR2で追加された分析関数の機能についても解説します。プログラム 1. count(*) over() 2. count(*) over() と minus 3. max(Val) over(partition by PID) 4. count(distinct Val) over(partition by PID) 5. Row_Numberとrankとdense_ran 阅读全文