2010年3月30日 星期二

[Oracle] 資料表的關連方式

SELECT

A.SERIAL_NUMBER "Barcode",
B.PART_NO "Model Name",
C.PDLINE_NAME "Line",
C.PDLINE_DESC "Line DESC",
A.STAGE_ID,
A.PROCESS_ID,
A.TERMINAL_ID,
A.OUT_PROCESS_TIME,
A.EMP_ID

FROM G_SN_TRAVEL A,
SYS_PART B,
SYS_PDLINE C

WHERE
A.MODEL_ID=B.PART_ID(+) AND
A.PDLINE_ID=C.PDLINE_ID(+) AND
TRUNC(A.OUT_PROCESS_TIME)=TO_DATE('2008-12-29','yyyy-mm-dd')
ORDER BY OUT_PROCESS_TIME

2010年3月24日 星期三

[C#] 動態產生物件 RadioButton 後,自訂事件

private void button2_Click_1(object sender, EventArgs e)

{
string[] KK = new string[3];
KK[0] = "Yes";
KK[1] = "No";
KK[2] = "Maybe";
System.Windows.Forms.RadioButton[] radioButtons = new System.Windows.Forms.RadioButton[3];
for (int i = 0; i < 3; ++i)
{
radioButtons[i] = new RadioButton();
radioButtons[i].Text = KK[i];
radioButtons[i].Location = new System.Drawing.Point(10, 10 + i * 20);
this.Controls.Add(radioButtons[i]);
}
radioButtons[0].Click += new System.EventHandler(this.OhYa_Click1);
radioButtons[1].Click += new System.EventHandler(this.OhYa_Click2);
radioButtons[2].Click += new System.EventHandler(this.OhYa_Click3);
}

private void OhYa_Click1(object sender, EventArgs e)
{
MessageBox.Show("1");
}

private void OhYa_Click2(object sender, EventArgs e)
{
MessageBox.Show("2");
}

private void OhYa_Click3(object sender, EventArgs e)
{
MessageBox.Show("3");
}

[C#] TreeView 用法

TreeNode node = treeView1.Nodes.Add("項目");

node.Nodes.Add("1");
node.Nodes.Add("2");
node.Nodes.Add("3");

SO,

[C#] 將Datatable 與 DataGridView 綁在一起

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("Item", typeof(string)));
dt.Columns.Add(new DataColumn("Color", typeof(string)));
dt.Rows.Add(new string[] { "table", "brown" });
dt.Rows.Add(new string[] { "chair", "white" });
dataGridView1.DataSource = dt;


操作的部分
            DataView view = new DataView(this._Table);
            view.RowFilter = "Item='" + "table" + "'";
            DataTable table = view.ToTable();
            dataGridView3.DataSource = table;

2010年3月2日 星期二

[Oracle] 日期的比對、搜尋 語法

日期的比對、搜尋 語法

試了好久,跟 SQL 真的差好多阿!!

SELECT * FROM 資料表


WHERE TRUNC(欄位名)=(SELECT TO_DATE('2008-9-20', 'yyyy-mm-dd') from dual)