技術メモ

        Dim strFile As String = "wk.pdf"

        Response.ContentType = "application/octet-stream"
        Response.AddHeader("Content-Disposition", "attachment; filename=" + strFile)
        Response.Flush()
        Response.TransmitFile("c:\00nham\" + strFile)
        Response.End()

 

--テーブルを宣言
create table nhamtbl1 (id varchar(10))
insert into nhamtbl1 values('aaa')

--ユーザ定義テーブル型を宣言
CREATE TYPE sampletabletype
  AS TABLE ( id varchar(10) )
go

--テーブル値パラメータを持つプロシージャを宣言
alter procedure sampleproc( @sampletable sampletabletype readonly)
as
 declare @id varchar(10)
 select @id = id from @sampletable
 print @id
go

--プロシージャ呼び出し
declare @sampletable sampletabletype
insert into @sampletable values('bbb')
exec sampleproc @sampletable

全てのメンバーを取得する
tp.GetMembers(Reflection.BindingFlags.Public Or Reflection.BindingFlags.NonPublic Or Reflection.BindingFlags.Instance Or Reflection.BindingFlags.Static Or Reflection.BindingFlags.DeclaredOnly)

Public Constの取得は下
tp.GetFields(Reflection.BindingFlags.Public Or Reflection.BindingFlags.Instance Or Reflection.BindingFlags.Static Or Reflection.BindingFlags.DeclaredOnly)
Private Constの取得は下
tp.GetFields(Reflection.BindingFlags.NonPublic Or Reflection.BindingFlags.Instance Or Reflection.BindingFlags.Static Or Reflection.BindingFlags.DeclaredOnly)
※但し、これ以外にも取得出来ちゃう？

フィールド、メンバ、プロパティの違い・・・