private void InitData_Spno(ComboBox cmbSpno)
{
//建立一個新連接配接
conn = new OracleConnection(ConnectionString);
conn.Open();
OracleCommand selectCmd = new OracleCommand("Select distinct Spareparts_no FROM T_BJ_InBound Order by Spareparts_no", conn);
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = selectCmd;
OracleDataReader dr = selectCmd.ExecuteReader();
while (dr.Read())
{
cmbSpno.Items.Add(dr[0].ToString()); //循環讀取資料
}
conn.Close();
}